All,
I have a data of start time and end time that represent and engine start and stop date/time. I have 10 engines. they could run for minutes, hours, >24 hours, days etc.
I would like to sum the time running for all hours of the day 0-24hr. A bar chart that sums the amount of hours for each hour of the day. If the engine runs from 1:30-3:30 then add 0.5 hours to 1 o'clock hour, 1hour to 2 o'clock, 0.5 hours to 3 o'clock.
I am having trouble writing a formula successful do this...especially for instances that start a 10pm on one day and end 2am the next day.
Any one have example of how to do this.
Shaun.
I have a data of start time and end time that represent and engine start and stop date/time. I have 10 engines. they could run for minutes, hours, >24 hours, days etc.
I would like to sum the time running for all hours of the day 0-24hr. A bar chart that sums the amount of hours for each hour of the day. If the engine runs from 1:30-3:30 then add 0.5 hours to 1 o'clock hour, 1hour to 2 o'clock, 0.5 hours to 3 o'clock.
I am having trouble writing a formula successful do this...especially for instances that start a 10pm on one day and end 2am the next day.
Any one have example of how to do this.
Shaun.