subtraction off time after midnight
Hello Roger
Excellent and Thankyou.
"Roger Govier" wrote:
Hi Steve
With 12:15 AM in A1 and 7:10 PM in A2
=MOD(A1-A2,1)
--
Regards
Roger Govier
"Steved" wrote in message
...
Hello from Steved
I have 7:10 p.m. to 12:15 a.m.
What formula do I use to subtract 12:15 a.m. from 7:10 p.m. please.
I would like it to show 05:05
Thankyou.
|