View Full Version : [SOLVED:] calculating time difference
austenr
11-21-2017, 03:24 PM
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
11-21-2017, 04:00 PM
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
11-21-2017, 04:12 PM
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
11-21-2017, 04:18 PM
=MINUTE(B1)-MINUTE(A1)
Then format the result as a number instead of time
austenr
11-21-2017, 04:31 PM
thanks off. that got exactly what i wanted.
Paul_Hossler
11-21-2017, 04:38 PM
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
11-21-2017, 04:57 PM
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.