Computing VTO Hours

Hi,

Need a help on this query: I need to compute the number of Voluntary Time Off within 8 hours shift.

Example:

B4 = 5:00 PM - 2:00 AM <---- Shift Line

B5 = 5:00 PM <---- log in time

C5 = 12:11 AM <--- log out time due to VTO

D5 = 1:49 <--- VTO hours

How will I be able to do this to avoid computing it manually?

Assuming exact strings as outlined (ie no leading zeroes for hours preceding 10) then:

Please Login or Register  to view this content.

Originally Posted by Locust

Great, but what if agent rendered full vto shift, Im getting a result of 0 where D5 should display 8:00 <---- full shift.

You will need to explain further - pref. by means of examples.
At present I can't follow your requirements given the initial post implied you wanted the difference between Actual End of Shift and Expected End of Shift - if the Actual = Expected I can't fathom why you would then want an answer of 8 rather than 0 (esp. given 5pm - 2am is 9 hours)

Originally Posted by Locust

When you say VOT, means Voluntary Overtime?

Is this also applicable on my query?

Sorry I mean VTO instead of VOT This means that the person goes before the actual shift
time. It is applicable to your query

Sorry for any confusion.

Thanks
Regard

Originally Posted by mahju

Because the computer calculates time combined with date, you have to include date if the shift spans on two dates

Just to be clear (in the hope of avoiding further unnecessary confusion) - as illustrated in post #2 in the context of the original question the above is not true and as such all subsequent suggestions are not warranted.

Originally Posted by DonkeyOte

You will need to explain further - pref. by means of examples.
At present I can't follow your requirements given the initial post implied you wanted the difference between Actual End of Shift and Expected End of Shift - if the Actual = Expected I can't fathom why you would then want an answer of 8 rather than 0 (esp. given 5pm - 2am is 9 hours)

Sorry for any confusion, I have already attached a sample template that we can utilize.

Scenerio: I need to determine the number of Voluntary Time Off hours for the ff employees that will be based on a 8 hours shift.

If an employee renders full VTO shift cell will display 8:00 [HH:MM].
( Since we all know that VTO is based from Log Off time - Remaining Hours left w/in the 8 hours shift. )

Kindly check the attached template for reference.

I confess that the requirement makes little/no sense to me but formula wise those requirements would look like:

Please Login or Register  to view this content.

Originally Posted by DonkeyOte

I confess that the requirement makes little/no sense to me but formula wise those requirements would look like:

Please Login or Register  to view this content.

Sorry if the requirement does not make any sense at all to you.

As for the formula the result is still the same:

cell E88 = 9:00 AM-6:00 PM ◄ Shift Line
cell I88 = 9:00 AM ◄ Log In Time
cell J88 = 9:25 AM ◄ Log Out Time
cell K88 = 8:35 ◄ VTO Hours were result should be 7:35


but ill try to figure this on my own now since I know now how to compute using the formula you gave me..

Thanks!