View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
trob trob is offline
external usenet poster
 
Posts: 1
Default How do I add numbers to time?

How do I add numbers to time? I have a start time in time format of 7:30 a.m.
I calculate a project will to 4.25 hours, in general number format, i.e., 4
hours and 15 minutes. When I add the two, it does not give me 11:45 a.m., but
instead it still shows 7:30 a.m. I tweaked with the format in the results
cell to no avail.