 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Time calculations
Excel 2003 I want to try to put together a store employee schedule for my son and I am wondering what is the best way to deal with time calculations. they do not use a 24 hour format so how can I do calculation (shift times, Employee availability times, sum of hours......) when the times are AM/PM format. Any guidance here will be appreciated. Thanks dave You can add and subtract times irrespective of the format. 17:00 less 08:00 returns 9:00 the same as 5:00 PM less 8:00 AM returns 9:00. You will need to use the number format to format answers correctly. When summing hours that exceed 24:00 then use custom format [h]:mm so that it remains in hours and minutes otherwise Excel thinks it is the next day. Example 12:00 + 13:00 is 25:00 but Excel will attempt to display it as 1:00 AM. Using the square brackets around the h displays as 25:00.  SignatureRegards, OssieMac > Excel 2003 > [quoted text clipped - 10 lines] > >
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.