Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Subtracting two times in hh:mm:ss format
I need to subtract two times that are in hh:mm:ss format and they occur on
different dates. Example: Time 1: 03/22/2005 19:09:47 Time 2: 03/23/2005 01:02:51 Result = Time 2 - Time 1 I've tried different things but I keep getting #VALUE! in the result cell. Any help would be appreciated. Thanks. |
#2
|
|||
|
|||
=ABS(MOD(B1,1)-MOD(A1,1))
HTH Jason Atlanta, GA -----Original Message----- I need to subtract two times that are in hh:mm:ss format and they occur on different dates. Example: Time 1: 03/22/2005 19:09:47 Time 2: 03/23/2005 01:02:51 Result = Time 2 - Time 1 I've tried different things but I keep getting #VALUE! in the result cell. Any help would be appreciated. Thanks. . |
#3
|
|||
|
|||
=ABS(MOD(B1,1)-MOD(A1,1))
HTH Jason Atlanta, GA -----Original Message----- I need to subtract two times that are in hh:mm:ss format and they occur on different dates. Example: Time 1: 03/22/2005 19:09:47 Time 2: 03/23/2005 01:02:51 Result = Time 2 - Time 1 I've tried different things but I keep getting #VALUE! in the result cell. Any help would be appreciated. Thanks. . |
#4
|
|||
|
|||
Make sure the cells are correctly formatted as date and time.
-- HTH RP (remove nothere from the email address if mailing direct) "A Khan" <A wrote in message ... I need to subtract two times that are in hh:mm:ss format and they occur on different dates. Example: Time 1: 03/22/2005 19:09:47 Time 2: 03/23/2005 01:02:51 Result = Time 2 - Time 1 I've tried different things but I keep getting #VALUE! in the result cell. Any help would be appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting Times with Strang Format | Excel Worksheet Functions | |||
Subtracting times | Excel Discussion (Misc queries) | |||
Subtracting Times | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions |