Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating the difference between hours
Hi, Where pls !! Waiting SAMI :confused -- Sambus ----------------------------------------------------------------------- Sambusa's Profile: http://www.excelforum.com/member.php...fo&userid=1496 View this thread: http://www.excelforum.com/showthread.php?threadid=26588 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating the difference between hours
I don't see a question here. If you want to work with time values, the
thing to remember is that Excel date/time values are stored as formatted numbers with the integer part representing the number of days since the beginning of 1900, and the fractional part representing the time of day (as a decimal fraction of 24 hours). Thus 8:30 AM is stored as 8.5/24 = 0.354166666666667 When formatted as a time, 0.354166666666667 displays as 8:30 AM. When formatted as a date/time, it displays as 1/0/1900 8:30:00 AM. When formatted as a number, 10/18/2004 8:30:00 AM displays as 38278.3541666667. Thus if you want to get the difference between times, you should make sure that the dates (if present) are appropriate. If times are input without dates, then you won't have to worry about it unless the times actually represent different days. Assuming that the dates are either appropriate or irrelevant, then =(timeEnd-TimeStart)*24 formatted as a number gives the number of hours between the two times. Jerry Sambusa wrote: Hi, Where pls !! Waiting SAMI |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating the difference between hours
If you intended that message for me, asking where to send your file, my email
address was in the message. On Mon, 18 Oct 2004 02:35:17 -0500, Sambusa wrote: Hi, Where pls !! Waiting SAMI |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating the difference between hours | Excel Programming | |||
Calculating the difference between hours | Excel Programming | |||
Calculating the difference between hours | Excel Programming | |||
Calculating the difference between hours | Excel Programming | |||
Calculating the difference between hours | Excel Programming |