Monday 13 April 2015

Convert time into Minutes

Converting time into minutes

Example C1 = 1:05:31
=HOUR(C1)*(60)+(MINUTE(C1))+SECOND(C1)/(60)

Output = 66 Minutes (Rounded Off)

 

No comments:

Post a Comment