Hi,
In our organization, we have quite a few people who work in both day and night shifts, ie,
they login at 10:30 AM and log out at 1:30 Pm with break from 11:30 to 11:45
Again they come at around 9 PM and will log out at 3 AM with dinner break at 10 PM , Tea breaks around 12 AM etc.
Normally their one day shift is a combination of both the morning shift and night shift.
Kindly help me calculate the total work hours.
Thanks!Combined shift times...JPG
Last edited by trisundara; 07-09-2019 at 12:11 PM. Reason: trying to explain ..
Welcome to the forum.
This has been asked many times before. Please take a look a this thread (one of very many): https://www.excelforum.com/excel-for...ven-shift.html
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks