In A46:
=(H13-D13)*24
and format as number

--
Regards,
Dave


"John L" wrote:


Hi, Thanks for letting me join your site. I've been looking for a site
that will help me with excel. Thanks

Here is my first question: I need to calculate the amount of hours i
spent on a job. Example: I started at 2:17 AM and finished at 7:34 AM.
on the sheet the first time is in cell 13D and the end time is in 13H.
I need the total number of hours in cell 46A.
What is the formula??

Thanks again. John


--
John L
------------------------------------------------------------------------
John L's Profile: http://www.excelforum.com/member.php...o&userid=34774
View this thread: http://www.excelforum.com/showthread...hreadid=545361