Thread: I need an Excel formula for converting hours to days?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anne Troy Anne Troy is offline
external usenet poster
  
Posts: 26
Default I need an Excel formula for converting hours to days?
Not sure if I understand the question, but try =YourFormula/24 and format the
cell to be a number with zero digits.
--
~Anne Troy
www.OfficeArticles.com


"Sharon Tischner" wrote:

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

Reply With QuoteReply With Quote