FF739johnny
New Member
- Joined
- Aug 25, 2019
- Messages
- 1
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.
<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>
[TD="class: xl64, width: 119"]Status[/TD]
[TD="class: xl64, width: 93"]Events[/TD]
[TD="class: xl64, width: 93"]Log In[/TD]
[TD="class: xl64, width: 119"]Date and Time[/TD]
[TD="class: xl64, width: 107"]Up Time [/TD]
[TD="class: xl67, width: 126"]Down Time[/TD]
[TD="class: xl68, width: 73"]Day 1 24[/TD]
[TD="class: xl63"]In Service[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl66"]0:00[/TD]
[TD="class: xl72"]0:00[/TD]
[TD="class: xl68"]Day 2 48[/TD]
[TD="class: xl63"]Red Tagged Onsite[/TD]
[TD="class: xl63"]Air Lines/Elec[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl65"]8/25/2019 12:30[/TD]
[TD="class: xl66"]12:30[/TD]
[TD="class: xl72"]7:00[/TD]
[TD="class: xl63"]Day 3 72[/TD]
[TD="class: xl63"]Red Tagged Onsite[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl66"]0:00[/TD]
[TD="class: xl72"]0:00[/TD]
[TD="class: xl63"]Day 4 96[/TD]
[TD="class: xl63"]In Service[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl66"]0:00[/TD]
[TD="class: xl72"]0:00[/TD]
[TD="class: xl63"]Day 5 120[/TD]
[TD="class: xl63"]Red Tagged Onsite[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl66"]0:00[/TD]
[TD="class: xl72"]0:00[/TD]
[TD="class: xl69"]Day 7 168[/TD]
[TD="class: xl63"]In Service[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl66"]0:00[/TD]
[TD="class: xl72"]0:00[/TD]
[TD="class: xl63"]Day 6 144[/TD]
[TD="class: xl63"]In Service[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl66"]0:00[/TD]
[TD="class: xl72"]0:00[/TD]
[TD="class: xl63"]Day 8 192[/TD]
[TD="class: xl63"]In Service[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl66, width: 107"]0:00[/TD]
[TD="class: xl72"]0:00[/TD]
[TD="class: xl63"]Day 9 216[/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl63"]Totals[/TD]
[TD="class: xl73"]180:30:00[/TD]
[TD="class: xl74"]7:00:00[/TD]
[TD="class: xl63"]Day 10 240[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl63"]Day 1 Sunday[/TD]
[TD="class: xl63"]Day 2 Monday[/TD]
[TD="class: xl63"]Day 3 Tuesday[/TD]
[TD="class: xl63"]Day 4 Wednesday[/TD]
[TD="class: xl63"]Day 5 Thursday[/TD]
[TD="class: xl63"]Day 6 Friday[/TD]
</tbody>
<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>
[TD="class: xl64, width: 119"]Status[/TD]
[TD="class: xl64, width: 93"]Events[/TD]
[TD="class: xl64, width: 93"]Log In[/TD]
[TD="class: xl64, width: 119"]Date and Time[/TD]
[TD="class: xl64, width: 107"]Up Time [/TD]
[TD="class: xl67, width: 126"]Down Time[/TD]
[TD="class: xl68, width: 73"]Day 1 24[/TD]
[TD="class: xl63"]In Service[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl66"]0:00[/TD]
[TD="class: xl72"]0:00[/TD]
[TD="class: xl68"]Day 2 48[/TD]
[TD="class: xl63"]Red Tagged Onsite[/TD]
[TD="class: xl63"]Air Lines/Elec[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl65"]8/25/2019 12:30[/TD]
[TD="class: xl66"]12:30[/TD]
[TD="class: xl72"]7:00[/TD]
[TD="class: xl63"]Day 3 72[/TD]
[TD="class: xl63"]Red Tagged Onsite[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl66"]0:00[/TD]
[TD="class: xl72"]0:00[/TD]
[TD="class: xl63"]Day 4 96[/TD]
[TD="class: xl63"]In Service[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl66"]0:00[/TD]
[TD="class: xl72"]0:00[/TD]
[TD="class: xl63"]Day 5 120[/TD]
[TD="class: xl63"]Red Tagged Onsite[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl66"]0:00[/TD]
[TD="class: xl72"]0:00[/TD]
[TD="class: xl69"]Day 7 168[/TD]
[TD="class: xl63"]In Service[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl66"]0:00[/TD]
[TD="class: xl72"]0:00[/TD]
[TD="class: xl63"]Day 6 144[/TD]
[TD="class: xl63"]In Service[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl66"]0:00[/TD]
[TD="class: xl72"]0:00[/TD]
[TD="class: xl63"]Day 8 192[/TD]
[TD="class: xl63"]In Service[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl66, width: 107"]0:00[/TD]
[TD="class: xl72"]0:00[/TD]
[TD="class: xl63"]Day 9 216[/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl63"]Totals[/TD]
[TD="class: xl73"]180:30:00[/TD]
[TD="class: xl74"]7:00:00[/TD]
[TD="class: xl63"]Day 10 240[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl63"]Day 1 Sunday[/TD]
[TD="class: xl63"]Day 2 Monday[/TD]
[TD="class: xl63"]Day 3 Tuesday[/TD]
[TD="class: xl63"]Day 4 Wednesday[/TD]
[TD="class: xl63"]Day 5 Thursday[/TD]
[TD="class: xl63"]Day 6 Friday[/TD]
</tbody>