Excel Formula

  chrischambers 16:20 12 Aug 06

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?

  VoG II 16:22 12 Aug 06

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


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 06

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


  chrischambers 16:33 12 Aug 06

Cheers Guys

  chrischambers 21:52 13 Aug 06

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

  sean-278262 21:59 13 Aug 06

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

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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5