Subtracting time from midnight hour...

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

I have a string of data (times) that are all within the midnight hour.
00:01
00:15
00:30
00:45
00:59

I would like to be able to subtract these from a previous hour within
the same day.
Ie.

00:01 - 23:30 = 29 (minutes)
00:15 - 23:15 = 30 (minutes)
00:30 - 20:30 = 4:00 (4hours 0 minutes)



Any ideas....?
 
00:01 - 23:30 = 29 (minutes)
00:15 - 23:15 = 30 (minutes)
Click to expand...

How do you arrive at those results? Shouldn't they be:

00:01 - 23:30 = 31 (minutes)
00:15 - 23:15 = 60 (minutes)

=MOD(A2-B2,1)
 
Back
Top