Subtracting dates, helpdesk is stumped

gene30 · Apr 2nd, 2002, 10:00 AM

This was given to our helpdesk who struck out. Here's the original question: How do I take 3/25/02 9:00PM and subtract 3/24/02 7:00PM to get time difference in decimal hours? Please email back spread sheet with example

Any ideas? Feel free to email me.

Asala42 · Apr 2nd, 2002, 10:03 AM

Hiya,

Try this:

(date1 - date2)*24

(format the cell for number)

That should do it.

Adam

kinkyparamour · Apr 2nd, 2002, 10:37 AM

This web page has lots of info about working with dates and times..........

http://www.cpearson.com/excel/datearith.htm

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 10:00 AM	#1
gene30 New Member Join Date: Apr 2002 Posts: 1	This was given to our helpdesk who struck out. Here's the original question: How do I take 3/25/02 9:00PM and subtract 3/24/02 7:00PM to get time difference in decimal hours? Please email back spread sheet with example Any ideas? Feel free to email me.

Apr 2nd, 2002, 10:03 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,306	Hiya, Try this: (date1 - date2)*24 (format the cell for number) That should do it. Adam

Apr 2nd, 2002, 10:37 AM	#3
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	This web page has lots of info about working with dates and times.......... http://www.cpearson.com/excel/datearith.htm