Excel Formula

  chrischambers 16:20 12 Aug 2006
Locked

Hope this is the right place to ask.
I want to enter one time in colum a another in colum b and the want the difference calculated in column c, any help please?
Thanks

  VoG II 16:22 12 Aug 2006

With earliest time in A1, latest time in B1, in C1 enter

=B1-A1

And format C1 as Time. If the time differences could exceed 24h then use a Custom format [h]:mm

  Young Ranger 16:30 12 Aug 2006

If you want the result in fractions of an hour rather then hours and minutes then in column D type

=HOUR(C1)+(MINUTE(C1)/60)

  chrischambers 16:33 12 Aug 2006

Cheers Guys

  chrischambers 21:52 13 Aug 2006

Hi again
If time a is 12:00 and time b is 11:50 how can I show it as 10 mins and not 23:50
Thanks

  sean-278262 21:59 13 Aug 2006

Put the earlier time in the other side of the formula.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

HP’s new Surface Pro rival is designed specifically for Adobe-using designers and artists

Best kids apps for iPhone & iPad

Que faire si son iPhone ou iPad est tombé dans de l'eau ?