 |
 | 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 / Worksheet Functions / October 2006I need an Excel formula for converting hours to days?
A1 A2 A3 18:15:00 22:00:00 4:15:00 PM 18:15:00 22:05:00 4:20:00 PM total 2:50:00 AM Not sure if I understand the question, but try =YourFormula/24 and format the cell to be a number with zero digits.  Signature~Anne Troy www.OfficeArticles.com > A1 A2 A3 > 18:15:00 22:00:00 4:15:00 PM > 18:15:00 22:05:00 4:20:00 PM > total 2:50:00 AM If the cell in the A3 column is intended to be the total of the same row's A1 and A2 cells, then formatting A3 as [h]:mm.ss will change it from 4:15:00 PM to 40:15:00. I can't see where your 2:50:00 AM total comes from. You asked, in your subject line though not in the body of your message, about converting hours to days. If you want your 40:15:00 displayed as days, then merely format it as General or Number. SignatureDavid Biddulph > A1 A2 A3 > 18:15:00 22:00:00 4:15:00 PM > 18:15:00 22:05:00 4:20:00 PM > total 2:50:00 AM I need the total number of hours to convert to days. This is for a reimbursement log sheet for a class I am taking. The result needs to calculate the total number of hours I will be entitled too when my class is done. thx st > If the cell in the A3 column is intended to be the total of the same row's > A1 and A2 cells, then formatting A3 as [h]:mm.ss will change it from 4:15:00 [quoted text clipped - 8 lines] > > 18:15:00 22:05:00 4:20:00 PM > > total 2:50:00 AM Whatever hours you've got formatted as [h]:mm:ss, add them up, and then (if you want the answer in days) format the result as general or number. SignatureDavid Biddulph >I need the total number of hours to convert to days. This is for a > reimbursement log sheet for a class I am taking. The result needs to [quoted text clipped - 3 lines] > thx > st >> If the cell in the A3 column is intended to be the total of the same >> row's [quoted text clipped - 10 lines] >> > 18:15:00 22:05:00 4:20:00 PM >> > total 2:50:00 AM |
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.