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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
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