Forum Discussion
To Add huge set of secs.milllisec to given time in hh:mm:ss.millisecs
Start time is 10:48:00.000 (10 - hr 48 - min 00 - secs 000 - milli secs).
Requirement to add huge set of secs.milli secs to the start time
Eg: 01.408 (01 - secs 408 - milli secs).
(Start tim...
Hello,
make sure the cells are formatted with custom number format h:mm:ss.000;@
Next, if you enter a second.millisecond number into a cell, you also have to enter the hour and minute as 0. For example enter 01.408 as 0:00:01.408 and enter 61.523 as 0:00:61.523. The last number will be converted to show as
| 0:01:01.523 |
and you can add it to the initial time value correctly.