Time Percentages

[FF739johnny]

I am working on a spreadsheet for my company that is requiring me to track the downtime of our trucks. I want to create/use a formula that will give me the time for 24, 48, 72, 96, 120, and 168 hours. So basically the total amount of hours would have to change everyday per formula. I have already added in a very basic formula to calculate all the hours total, I just need help with the formula for the percentages for the certain hour span.

Status	Events	Log In	Date and Time	Up Time	Down Time	Day 1 24
In Service				0:00	0:00	Day 2 48
Red Tagged Onsite	Air Lines/Elec		8/25/2019 12:30	12:30	7:00	Day 3 72
Red Tagged Onsite				0:00	0:00	Day 4 96
In Service				0:00	0:00	Day 5 120
Red Tagged Onsite				0:00	0:00	Day 7 168
In Service				0:00	0:00	Day 6 144
In Service				0:00	0:00	Day 8 192
In Service				0:00	0:00	Day 9 216
			Totals	180:30:00	7:00:00	Day 10 240
			Day 1 Sunday
			Day 2 Monday
			Day 3 Tuesday
			Day 4 Wednesday
			Day 5 Thursday
			Day 6 Friday

<colgroup><col style="mso-width-source:userset;mso-width-alt:4165;width:90pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:3234; width:70pt" width="93" span="2"> <col style="mso-width-source:userset;mso-width-alt:4165;width:90pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:3723;width:80pt" width="107"> <col style="mso-width-source:userset;mso-width-alt:4398;width:95pt" width="126"> <col style="mso-width-source:userset;mso-width-alt:2536;width:55pt" width="73"> </colgroup><tbody>
</tbody>

 

[James006]

Hi,

You only to take whatever duration ... and format the cell as percentage ...

Hope this will help