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

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 :confused:

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 :confused: