G
Guest
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.
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.