day of the week and date formula

S

Sarah Elliott

Hello

I am looking to write a formula that gives me the difference in hours
between a logged date and time and a closed date and time eg -27/11/2009
09:23:26 and
30/11/2009 10:34:20. Once I have this I need to calculate the working
hours used to resolve the issue. If the duration of the time includes a
weekend, a saturday would equate to 4 hours working and a sunday would be 0
hours working time, a week day equates to 11.5 hours working.

Any suggestions??

Thanks
 
S

Shane Devenshire

Hi,

we need to know what hours during any day are considered working - ie, do
all hours of the day count as working hours or only certain ones?
 

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

How to implement two shifts per day with multiple teams 0
formula help 3
How to calculate difference between two date & time along with working hours and days 2
IF OR Formula 1
Finding the week of date 4
date to show then end of the week 2
need help with Formula 1
Can I create my own date showing day of week plus date? 2

Top