Time formula calculation

[Rescueme]

Cell C1 has start time, Cell D1 has end time, Need formula in Cell E1 to
calculate how much time was involved.

Using Excel 2000 - cell C1 & D1 formatted with time in the following formatt
2:00 PM
C1 = 2:00 PM
D1 = 3:30 PM
E1 = 1.5 hours

Thanks for your help
Karen
(e-mail address removed)

 

[Paul B]

Karen, try this in E1 =(D1-C1)*24

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

 

[Rescueme]

Thanks Paul,

I knew it was simple, I had the formula in before but today I was having a
blonde moment!!

Karen
(e-mail address removed)

 

[David McRitchie]

Karen and Paul,
You may also have seen
=(D1-C1+(C1>D1))*24

The (C1>D1) will add 1 day (24 hours) if the time measured
runs through midnight.

More on Date and Time in
http://www.mvps.org/dmcritchie/excel/datetime.htm