Using hours and minutes in an If/Then statement

[Ron Purpura]

Hello All
Another If/then statement question relative to time:

Pretty simple spreadsheet, I am just having an issue with the if/then statement:

Trying to help a friend with his vacation calculations and example attached

Cell B21 he starts with 157 hours and 59 minutes of vacation

Row 23 reflects vacation time used(if any) during his accrual period.

Row 26 reflects his 6 hours and 10 minutes of vacation accrual ( which is a constant)

Row 27 reflects time remaining at end of accrual period

My struggle is, when writing the if/then statement (see cell c21) is as follows...He cannot carry more than 160 hours of vacation, so in essence he is actually losing vacation if he does not take it, hence the reason for the spreadsheet. Anyways,as you can see, my statement is not reflecting the max of 160 hours in row 21. Any help is greatly appreciated

Thanks in advance
Ron

[TMS]

You are comparing a time,albeit many hours, to a number. A time is a fraction of a day, for example, 1 hour is 1/24th of a day.

You need something like:

Please Login or Register  to view this content.

... formatted as general.


Regards, TMS

[Ron Purpura]

Thank you so much TMS..

[TMS]

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[ChemistB]

FYI, An alternative formula would be

Please Login or Register  to view this content.