Calculating the difference between hours

S

Sambusa

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/Calculating_the_difference_between_hours_in_Microsoft_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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculating difference between date/time fields 19
Calculation of Overlap Outage Hours 17
Difference between 2 times 2
Calculating diff between date/ time only between certain hours 5
Calculate difference between hours 5
Sum work hours to hours & nearest 10th of an hour 14
Response times calculated in business hours 9
Hours difference 3

Top