View Full Version : Excel subtract time
08-04-2002, 04:11 PM
how would you subtract 7:00pm from 8:30pm?
08-04-2002, 07:32 PM
What is the answer supposed to be? 1:30 PM or 1.5 hours?
08-04-2002, 08:01 PM
I have tried =d13-d14
can not find anything in help to subtract or add time values.
08-04-2002, 09:12 PM
where A1 = 8:30 PM and B1 = 7:00 PM
08-04-2002, 09:13 PM
d13-d14 should work just fine. But the answer will be in terms of days. So try modifying it to:
24*(d13-d14) and you should get the result you're hoping for.
Edit: just tested and confirmed for Excel 2000
08-04-2002, 10:18 PM
Oh, okay, the simpler formula.
08-05-2002, 07:57 AM
I thank you for all your support.
vBulletin® v3.7.6, Copyright ©2000-2013, Jelsoft Enterprises Ltd.