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)

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)

--
Biff
Microsoft Excel MVP


"J.W. Aldridge" <jeremy.w.aldridge@gmail.com> wrote in message
news:2b2cfdd0-f1a3-4748-9727-bf50ffb2ebd3@b1g2000hsg.googlegroups.com...
>
> 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....?

PURFECTO!

Thanx

You're welcome!

--
Biff
Microsoft Excel MVP


"J.W. Aldridge" <jeremy.w.aldridge@gmail.com> wrote in message
news:6790c7f4-dc46-493b-8171-4bd5c6b2cc8c@j22g2000hsf.googlegroups.com...
> PURFECTO!
>
> Thanx