How to calculate between two date/time fields?

C

Cam

Hello,

How do I calculate the time in hours or days between two fields (startDate
and FinishDate in Date/Time format 8/12/2008 14:41) less weekend and holiday?

Example:
StartDate FinishDate Result
8/12/2008 12:09 8/12/2008 14:41 92 mins or 1.53 hrs or 0.936
days

Thanks
 
S

smartin

Cam said:
Hello,

How do I calculate the time in hours or days between two fields (startDate
and FinishDate in Date/Time format 8/12/2008 14:41) less weekend and holiday?

Example:
StartDate FinishDate Result
8/12/2008 12:09 8/12/2008 14:41 92 mins or 1.53 hrs or 0.936
days

Thanks
Click to expand...

Hi Cam,

Chip Pearson has some good info on this:

http://www.cpearson.com/excel/holidays.htm
 

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

number of months and days between two dates without approximation 3
Date and Time 1
Calculate elapsed time excluding specific timeframe 10
Calculating the difference, in hours, between two date/time in two different time zon 2
Need to pull <=14 Days, <=30 Days, >30 Days from a date column 3
How to calculate difference between two date & time along with working hours and days 2
Calculate date difference exclude Wkend 4
Date time difference 5

Top