Time based on constraints

M

MrsJparty

Is there a way to calculate time based on 16 hour days.
I'm tracking machine downtime. Shift hours are 6am - 2:30
and 2:30 - 10pm. Machine goes down on Friday 10am and
back up and running on Monday 11am. Based on 16 hour day,
how long was that machine down?

Thanks
 

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

Combine multiple tables with different date ranges 2
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Graph usage for times of day 0
How to calculate difference between two date & time along with working hours and days 2
Time calculation 2
Multiply constant by date range 4
Problem with Time portions of the day 2
Counting Concurrent timed events 8

Top