Time formula calculation

  • Thread starter Thread starter Rescueme
  • Start date Start date
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
(e-mail address removed)
 
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 **
 
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)
 
Back
Top