Excel formula to convert time to 100 minute

August 31, 2010 at 04:25:58
Specs: Windows XP
i want to calculate times worked each day, eg: a2 = 8:45 and a3 = 16:30. But I need it to calculate instead of it equalling 7.45hrs I need to convert it to 100 minute, eg it should calculate to 7.75. any suggestions?

See More: Excel formula to convert time to 100 minute

Report •


#1
August 31, 2010 at 06:35:21
Hi,

Try this formula:

=HOUR(A3-A2)+MINUTE(A3-A2)/60

Format the cell with the formula as a number with two decimal places.

The formula returns the complete hours plus the minutes expressed as a fraction of an hour.

Regards


Report •

#2
August 31, 2010 at 20:47:33
thank you so much - legendary!!

Report •

#3
September 1, 2010 at 06:37:49
You're welcome

Regards

Humar


Report •

Related Solutions


Ask Question