| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Formula
Hey Thanks that work.
Now my schedule is complete. "Peo Sjoblom" wrote: Custom format the cell as [hh]:mm then use =A1+(9/24) or if integers only =(A1*24)+9 format as general -- Regards, Peo Sjoblom "Brandon" wrote in message ... Here is what I have in cell A1 I have this number 22 which is convert from another cell which is 10 pm and I have tried this =A1+9 but it only returns 22:00 and I have tried to format it different ways but I never get 31. What I'm I doing wrong with this or is there another way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert from percentage of time to time using complex formula in . | Excel Worksheet Functions | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| Help with time formula so the time will not change. | Excel Discussion (Misc queries) | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Hybrid Mode
