# Computing VTO Hours

1. ## 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

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?

2. ## Re: Inquiry: Computing VTO Hours

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

``Please Login or Register  to view this content.``

3. ## Re: Computing VTO Hours

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

in B5 & C5 enter time in m/dd/yy hh:mm format as 12/24/10 5:00 pm

in cell D5 enter
=INT(ABS(((C4-B4)*24)-9))
This will calculate Hours

In cell E5 enter
=round(INT(ABS(((C4-B4)*24)-9)),0)
This will calculate Hours
This is only for VOT Hours not for Over time

Regards

4. ## Re: Inquiry: Computing VTO Hours

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

``Please Login or Register  to view this content.``
Great, but what if agent rendered full vto shift, Im getting a result of 0 where D5 should display 8:00 <---- full shift.

5. ## Re: Computing VTO Hours

Originally Posted by mahju
Because the computer calculates time combined with date, you have to include date if the shift spans on two dates as mentioned in example

in B5 & C5 enter time in m/dd/yy hh:mm format as 12/24/10 5:00 pm

in cell D5 enter
=INT(ABS(((C4-B4)*24)-9))
This will calculate Hours

In cell E5 enter
=round(INT(ABS(((C4-B4)*24)-9)),0)
This will calculate Hours
This is only for VOT Hours not for Over time

Regards

When you say VOT, means Voluntary Overtime?

Is this also applicable on my query?

bump
bump

7. ## Re: Inquiry: Computing VTO Hours

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)

8. ## Re: Computing VTO 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

9. ## Re: Computing VTO Hours

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.

10. ## Re: Inquiry: Computing VTO Hours

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.

11. ## Re: Computing VTO Hours

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.``

12. ## Re: Computing VTO Hours

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 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!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1