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?

Hi, Try this formula:

=HOUR(A3-A2)+MINUTE(A3-A2)/60Format 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

thank you so much - legendary!!

You're welcome Regards

Humar

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History