Making a weekly time sheet. How do I change 1:30 Time Value (one hour & 30 minutes) to 1.5 hours for calculating purposes? Thanks for your expert help! Free timesheet software, free DVD Collection software - Timesheets MTS :: Free timesheet software from Timesheets MTS Software Weve spent a lot of time making our timesheet interface quick and easy to use. http://www.timesheetsmts.com/freesoftware.htmHOME |
Making a weekly time sheet. How do I change 1:30 Time Value (one hour & 30 minutes) to 1.5 hours for calculating purposes? Thanks for your expert help! Online Timesheet System - Rule Descriptions:: Comp Time Off Usage. Consecutive Work Days. New Timesheet Data. Disability The Online Timesheet System has Monthly Exception employees report time from the http://timesheets.ucdavis.edu/help/RuleDescriptions.aspxHOME |
Multiply by 24 and format as a number.
Correction: Making a weekly time sheet. How do I change 1:30 Time Value (one hour & 30 minutes) to 1.5 hours for calculating purposes? Thanks for your expert help! Sorry, I'm not yet familiar with the methods of this forum. Tenrox Timesheet - Webinar registration form:: Tenrox is a leading provider of web based project, time and expense tracking software and services. Our software, Office Timesheet, is designed for industries with http://www.timesheet.com/webinars/webinars.aspHOME |
Not sure if this answer is the best way. The way I understand it in Column A you input (start) 12:00 and in Column B you input (finish) 13:30 (for pm). You want a formula to give you 1.5 versus 1:30?
Try this... =(HOUR(start)-HOUR(finish))+(MINUTE((HOUR(start)-HOUR(finish))/60)
Traditional University or MLM University? You Choose
15 Questions to Ask Your Software Vendor
|