LinkBack URL
About LinkBacks
Hello experts. Please help. I need to calculate downtime (number of hours) on a timesheet. Not sure how to do this... see sample file attached.
downtime sample.xlsx
Hello experts. Please help. I need to calculate downtime (number of hours) on a timesheet. Not sure how to do this... see sample file attached.
downtime sample.xlsx
It would help if you manually put in what you think the downtimes would be in your example file. Also, a description of how you calculate it would not go amiss.
Pete
Suggest you explain in simple English what you are trying to achieve. From your thread and worksheet, it is not clear. While many here have exceptional excel skills, mind reading is not among the skills. Tell us specifically what you are trying to do.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
OK, my apologies. Thank you for taking the time to review. Downtime = # of hours from last date worked Time Out (column C) to current date Time In (column B). Additional explanation and expected values included in attached.
downtime sample v2.xlsx
Try this in E10 and copy down:
=((A10+B10)-(A9+C9))*24+IF(B10="",24,0)+IF(B9="",E9-24,0)
Edit: too many paranthesis...this looks a little neater.
=(A10+B10-A9-C9)*24+IF(B10="",24,0)+IF(B9="",E9-24,0)
Last edited by Beamernsw; 01-08-2016 at 02:51 AM.
Fantastic. Brilliant. This is exactly what I need. Thank you!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks