Hi for all,
I am so happy to get goooood site like this i realy appreciate all o
u,
Can i know how to calculate the difference between hours,
I have check this:

http://www.exceltip.com/st/Calculati..._Excel/97.html

But what i want is to calculate the time between hours for only wokin
hours

Example ( If u i have cars to go around the cities i would like to kno
how many hours( work hour ) the car was with the driver )

Taken date & time Return date & time
10:30 25/9/2004 23:10 28/9/2004

The work hours from 5 AM to 6 PM


Pls reply to me asap
Thanks in advance
SAM

--
Sambus
-----------------------------------------------------------------------
Sambusa's Profile: http://www.excelforum.com/member.php...fo&userid=1496
View this thread: http://www.excelforum.com/showthread.php?threadid=26588

Hi
see:
http://www.cpearson.com/excel/DateTimeWS.htm

--
Regards
Frank Kabel
Frankfurt, Germany


Sambusa wrote:
Hi for all,
I am so happy to get goooood site like this i realy appreciate all of
u,
Can i know how to calculate the difference between hours,
I have check this:


http://www.exceltip.com/st/Calculati...ween_hours_in_
Microsoft_Excel/97.html

But what i want is to calculate the time between hours for only
woking
hours

Example ( If u i have cars to go around the cities i would like to
know how many hours( work hour ) the car was with the driver )

Taken date & time Return date & time
10:30 25/9/2004 23:10 28/9/2004

The work hours from 5 AM to 6 PM


Pls reply to me asap
Thanks in advance
SAMI