Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding or combining time problem.
I am trying to simply add times h:mm format.
=TEXT(F22-"37:30","h:mm") =TEXT(F49-"37:30","h:mm") These can and do give negative results because I am using the 1904 date system. But, if I try to sum the result of these two if any have a negative result I get an error. I am using the below for the sum: =F23+F50 all h:mm So how do I add values when one is negative? Or is there another way? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding small units of time and entering them quickly | Excel Discussion (Misc queries) | |||
Time log adding time from separate sheets | New Users to Excel | |||
Problem with formatting time | Excel Discussion (Misc queries) | |||
Date time problem | Excel Discussion (Misc queries) | |||
1/0/1900 10:18:48 AM Time problem | Excel Worksheet Functions |