Time Elapse

[Nucjpra]

I am trying to set up a start time and end time worksheet to calculate total hours between evolutions. When I put my start date in A2 and my end time in B2 the difference I get is 7 hours. The time I am using is start 0900am (8/2/02) and end 1600 (8/3/02). This should be a difference of 31 hours in reality. Cannot get it to work in excel. Please help

 

[elgringo56]

This is dirty, but it works. Format Cells A1 thru E1 for numbers. In cell A1, enter 1 for day 1. In B1 enter the time as a decimal number, ie 9:00=9, 9:30=9.5. In Cell C1 enter the stop day as day 1, 2, 3 etc. In Cell D1 enter the time again as a decimal number. In Cell E1 enter the formula =((C2-A2)*24)+(D2-B2) The answer will be in the number of hours worked

 

[Yogi Anand]

Hi Nucjpra:

Welcome to the Board!

The result cell should be Custom Formated as [h]:mm:ss ... see the worksheet simulation

y020907.xls
	A	B	C	D
1
2	8/2/029:00	8/3/0216:00	31:00:00
3			CellC2shouldhaveCustomFormat[h]:mm:ss
4
Sheet2

</SPAN>

Regards!

Yogi
This message was edited by Yogi Anand on 2002-09-06 23:02

 

[Nucjpra]

Thansk Yogi and the others for the splendid information. Keep excelling!!!!