Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I would like to be able to do is to input a negative. All of the previous
posts seem to show how to show the result of subtracting a large number of hours from a smaller number - The 1904 format will give the negative answers results. I would like to be able to enter -ve times such as -1hr 24m in one of the input cells in order total a row of times e.g. A1 B1 C1 2:00 -1:24 = 0:34 =sum(a1:b1) etc 2:00 -3:13 = -1:13 is this possible? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating time and negative time | Excel Worksheet Functions | |||
calculation with hours and minutes - input of negative values | Excel Discussion (Misc queries) | |||
Time Input | Excel Discussion (Misc queries) | |||
Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
can you input time (hh:mm:ss) without having to input the colon i. | Excel Discussion (Misc queries) |