New Member
November 16, 2016
Hi just wondering how to create a formula for a daily total but across two days with 30min break that will still calc OT like
10/01/16 20:00 to 10/01/16 23:30 3.5hrs
10/02/16 24:00 to 10/02/16 8:30 8.5 hrs so 12 hours total how do i show this daily total as 12 even though it crosses more than one day, and is there a way to have it automaticallly separate the OT? THANK YOU FOR ALL YOUR HELP
SRICE831
VIP
Trusted Members
June 25, 2016
VIP
April 21, 2015
Hi Sunny,
Nice solution your second one! Didn't know how to use the 'time' function in a clever way and here it is. Only thing is (of course) you have to ad your pause time somewhere else and then it's calculated, but that's some further elaboration. It's a pity we didn't hear anything from our new member who asked it?
VIP
Trusted Members
June 25, 2016
Hi Frans
Feedback is important.
We just don't know if the solution is workable as we don't get any feedback at all. Maybe they already got the solution from somewhere else.
Somehow I find that Time is pretty tough to handle in Excel, especially those that require to exclude certain working hours etc. like those in a time sheet. One member asked for an SLA (expected time taken to answer a helpdesk question) and I worked on it for a couple of days but still not able to find a solution that works perfectly in all conditions. Then again maybe I am not that good at Time 🙁
The SLA question is still not answered until now.
Sunny
VIP
April 21, 2015
VIP
Trusted Members
June 25, 2016
1 Guest(s)