Forum Discussion
Excel - calculating hours worked on single cell values
In I3 as an array formula, confirmed with Ctrl+Shift+Enter:
=SUM(IFERROR(MOD(TIMEVALUE(RIGHT(B3:H3,5))-TIMEVALUE(LEFT(B3:H3,5)),1),0))Apply the custom number format [h]:mm to I3, then fill down.
Could you help me? I have tried but it just isn't working. I'm using excel but it wouldn't let me share can you use make it excel and send the formatted
https://docs.google.com/spreadsheets/d/1djNKW9ySHkqCTU1U55ZryvuI-we9BDEAzVPO5cc-6qA/edit?usp=sharing
I get "You need access" when I click your link...
- https://docs.google.com/spreadsheets/d/1djNKW9ySHkqCTU1U55ZryvuI-we9BDEAzVPO5cc-6qA/edit?usp=sharing
Try nowThank you. In the first post in this discussion, working times were specified in the form 09:00-17:30, i.e. with a leading zero where needed, and with : as delimiter.
In your workbook, the times are in the form 900-1730, i.e. without leading zero and without delimiter. This requires a slightly different formula - see the attached version.