Did u Meant this...
Emergency Time = if(No of Days * 8 > Hours of Vacation Time Taken, (No of Days *8) - Total Vacation Time Taken,"")
Saurabh
Main Topics
Browse All TopicsHello Experts,
I need some assistance writing this If then Else statement in Excel. I've only really begun to dabble in Excel and you'll find the logic I'm hoping to translate is written more along the lines of VBScript. This logic is untested at the moment so I may have to ask for help in making any adjustments. I promise not to take too much of anyone's time with re-work without rewarding for it.
Here's the problem history in brief: I'm creating a spreadsheet to track vacation time. Employees are given X amount of days vacation. Within those X days, they are given 8 hours of Emergency time to use as they see fit. The employee can only have as much emergency time (up to 8 total hours) as they have vacation time available so if vacation time is less than 8 hours, emergency time needs to reflect that.
Thanks for your time.
s_r
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Business Accounts
Answer for Membership
by: roryaPosted on 2007-12-19 at 09:26:37ID: 20501171
Are you trying to do this in code or in a formula? Seems to me, you basically need on_minutes ])
=MIN(480-[Used emergency minutes],[Available_vacati
Regards
Rory