Subtracting time from midnight hour...

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....?
 
T

T. Valko

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

15 minute data to daily data 1
Suming Up Time over the course of days 1
Subtracting time...again 2
<<Extracting the desired data with an formula>> 10
Tally the figures acquired from the same date 3
Cumulative Timesheet Calculations 0
Determine if night shift by start & end time 2
Graph usage for times of day 0

Top