| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to show non decimal hours
Ideally input in hours format, i.e. with a colon ":", e.g. if A1 is 1:01 and
B1 is 0:59 then the formula =A1+B1 will give you 2:00 "colgar65" wrote: How do I get a formula to add up over the hour mark not using : IE 1.01 + 0.59 = 1.01 hours not as adds up to 1.61 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to show non decimal hours
If you don't want to use : try this formula
=TEXT(TEXT(A1*100,"0\:00")+TEXT(B1*100,"0\:00"),"h h.mm")+0 format as number "daddylonglegs" wrote: Ideally input in hours format, i.e. with a colon ":", e.g. if A1 is 1:01 and B1 is 0:59 then the formula =A1+B1 will give you 2:00 "colgar65" wrote: How do I get a formula to add up over the hour mark not using : IE 1.01 + 0.59 = 1.01 hours not as adds up to 1.61 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to add hours and show actual hours not decimal numbers | New Users to Excel | |||
| How to show the formula and the answer? | Excel Discussion (Misc queries) | |||
| Working Hours (formula & graph) - any elegant solution? | Excel Worksheet Functions | |||
| Need formula to calculate hours worked | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
Linear Mode
