Time formula calculation

R

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
[email protected]
 
P

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 **
 
Top