calculating time difference

[austenr]

What is the formula to give the difference in minutes in the following cells. The formula I have includes the hours which is inconsequential for my result. I just need the minutes between the time.


11/6/2017 10:38 11/6/2017 18:57 8:19

[Paul_Hossler]

Excel's Date/Time are in Days and fractions of Days

So subtracting the two dates gives you the difference in (fraction of) days and multiplying by 24 * 60 converts days to minutes


21007

[austenr]

Paul,

So if you calculate it by hand the real difference between 10:38 and 18:57 in minutes minus the 8 hours is 19 minutes. Not quite following the formula and how you get 499. However if you subtract 480 from it (60 minutes in and hour *8 I get 20). Looks =like its rounding up.


=24*60*(D7-C7)-480

[offthelip]

=MINUTE(B1)-MINUTE(A1)

Then format the result as a number instead of time

[austenr]

thanks off. that got exactly what i wanted.

[Paul_Hossler]

What is the formula to give the difference in minutes in the following cells.

I misunderstood - I thought you wanted the difference in minutes, not the difference in THE minutes

But at least you got your answer


BTW, will that work if the start time is 12:50 and the end is 14:10?

[austenr]

thanks Paul. no i dont believe it will but for these purposes i just need to know the difference in punch in and out times. However it might come into play if the individual forgets to punch out or in.