Notifications
Clear all
General Excel Questions & Answers
6
Posts
3
Users
0
Reactions
108
Views
Topic starter
Dear All,
Can anyone please explain me how to calculate number of work hours in excel for below examples:
1. Time in 4:00 am 1/1/2021
Time off 6.00 am 2/1/2021
2. Time in 8:30 am 1/1/2021
Time off 8.30 am 2/1/2021
Thank you
Navoda
Posted : 20/05/2021 11:41 pm
Hi Navoda,
Welcome to our forum. calculating times between a start and end time on different dates is explained in this post under the heading "Shift Work Timesheets and Overtime".
If you get stuck, please come back and upload a sample Excel file illustrating the problem.
Mynda
Posted : 21/05/2021 2:32 am
Topic starter
Dear Mynda,
Thank you very much. I'll try these excel formulas and will you a feedback.
Navoda.
Posted : 21/05/2021 5:28 am
Topic starter
Dear Mynda,
Here I have attached the excel I tried to find out the worked hours. but the answers are wrong (Highlighted in yellow)
Navoda.
Posted : 21/05/2021 10:52 am
Hello,
There are no formulas in your file. For simplicity, do add dates with your time, then it all works fine.
Br,
Anders
Posted : 21/05/2021 12:36 pm
Topic starter
Dear Anders,
Thank you for your reply.
Navoda
Posted : 21/05/2021 11:43 pm
