|
|
|
|||||||
| FlashChat | Actuarial Discussion | Preliminary Exams | CAS/SOA Exams | Cyberchat | Around the World | Suggestions |
Berlin - Madrid - Rome
- Paris - Hamburg - Warsaw |
 |
|
|
Thread Tools | Display Modes |
|
#1
08-04-2002, 04:11 PM
|
|||
|
|||
Excel subtract time
how would you subtract 7:00pm from 8:30pm?
|
|
#2
08-04-2002, 07:32 PM
|
||||
|
||||
|
What is the answer supposed to be? 1:30 PM or 1.5 hours?
__________________
Up and at them.
|
|
#3
08-04-2002, 08:01 PM
|
|||
|
|||
|
the result.
1.5 hours.
I have tried =d13-d14 =time(d13)-time(d14) can not find anything in help to subtract or add time values.
|
|
#4
08-04-2002, 09:12 PM
|
||||
|
||||
|
Try:
((60*hour(A1)+minute(A1))-(60*hour(B1)+minute(B1)))/60 where A1 = 8:30 PM and B1 = 7:00 PM
__________________
Up and at them.
|
|
#5
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
|
|
#6
08-04-2002, 10:18 PM
|
||||
|
||||
|
Oh, okay, the simpler formula.
__________________
Up and at them.
|
|
#7
08-05-2002, 07:57 AM
|
|||
|
|||
|
Why thank you.
I thank you for all your support.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
