Indeed I did.
Thanks for catching the typo, Bob

--
Regards

Roger Govier


"Bob Phillips" wrote in message
...
I think Roger means

=MOD(B1-A1,1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Roger Govier" wrote in message
...
Hi Kat

With start in A1 and End in B1
=MOD(B1,A1,1)
will deal with either scenario

--
Regards

Roger Govier


"kat" wrote in message
oups.com...
That works great when the time is within the same day, but when it
starts at 10:00PM and ends at 2:00AM I can't calculate the hours.

Currently I just threw out their format and used your solution with
the
if function: =IF(b1a1,"24:00"-(a1-b1),b1-a1) Maybe I overdid
it??
but it seems to work fine.

Just curious if anyone has ever come across the weird format I
described in the first post. I thought maybe it was some MVP
supersolution