Subtracting dates, helpdesk is stumped

[gene30]

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]

Hiya,

Try this:

(date1 - date2)*24

(format the cell for number)

That should do it.

Adam

 

[kinkyparamour]

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


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