Actuarial Outpost Excel subtract time
 Register Blogs Wiki FAQ Calendar Search Today's Posts Mark Forums Read
 FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

 Berlin - Madrid - Rome - Paris - Hamburg - Warsaw Barcelona - Vienna - Milan - Munich - Prague - Cologne Actuarial Jobs in Europe Athens - Amsterdam - Frankfurt - Copenhagen Hannover - Dublin - Brussels - Lyon - Zurich

#1
08-04-2002, 04:11 PM
 Packet_Storm Member Join Date: Feb 2002 Location: At a desk. Posts: 182
Excel subtract time

how would you subtract 7:00pm from 8:30pm?
#2
08-04-2002, 07:32 PM
 Radioactive Man Member Join Date: Sep 2001 Location: To pronounce it correctly, I would have to tear out your tongue. Posts: 484

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
 Packet_Storm Member Join Date: Feb 2002 Location: At a desk. Posts: 182
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
 Radioactive Man Member Join Date: Sep 2001 Location: To pronounce it correctly, I would have to tear out your tongue. Posts: 484

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
 urysohn Guest Posts: n/a

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
 Radioactive Man Member Join Date: Sep 2001 Location: To pronounce it correctly, I would have to tear out your tongue. Posts: 484

Oh, okay, the simpler formula.
__________________
Up and at them.
#7
08-05-2002, 07:57 AM
 Packet_Storm Member Join Date: Feb 2002 Location: At a desk. Posts: 182
Why thank you.

I thank you for all your support.

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off

All times are GMT -4. The time now is 06:23 PM.

 -- Default Style - Fluid Width ---- Default Style - Fixed Width ---- Old Default Style ---- Easy on the eyes ---- Smooth Darkness ---- Chestnut ---- Apple-ish Style ---- If Apples were blue ---- If Apples were green ---- If Apples were purple ---- Halloween 2007 ---- B&W ---- Halloween ---- AO Christmas Theme ---- Turkey Day Theme ---- AO 2007 beta ---- 4th Of July Contact Us - Actuarial Outpost - Archive - Privacy Statement - Top