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

Calculate After hours 3
Calculation of Overlap Outage Hours 17
How to calculate difference between two date & time along with working hours and days 2
Calculate difference between hours 5
Calculating time for 3rd shift 4
Calculating diff between date/ time only between certain hours 5
calculating difference between date/time fields 19
Calculate if 2 times differ by 24 hours? 8

Top