Utilization calculation challenge

  • Thread starter Thread starter Herb Wagner
  • Start date Start date
H

Herb Wagner

I have a spreadsheet that shows crane usage. I want to calculate tota
hours used by each crane by shift
(i.e. 7:30-15:30 = "Day Shift") etc. I also need to count the number o
shifts for each crane.

Can anyone suggest a formula/approach? A portion of the spreadsheet i
attached with the layout of the result I'm trying to achieve.

Thanks,
Her

Attachment filename: cranetime.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63424
 
Hi Herb!

What shift would this be considered?

14:45 - 15:50

How do you want to handle times that span multiple shifts?

Biff
 
Also noticed that in your total hours charged, some values
are rounded up and some are rounded down?

For example:

29 mins is rounded up to 1 hr
65 mins is rounded down to 1 hr

?????

Biff
 
Back
Top