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...
Armanath,
and if you want to type the numbers as seconds,milliseconds then:
| A | B | C | |
| 5 | 10:48:00,000 | 1,408 | 10:48:01,408 |
| 6 | 10:48:00,000 | 61,523 | 10:49:01,523 |
| 7 | 10:48:00,000 | 3600,478 | 11:48:00,478 |
| Cell | Formula |
| C5 | =A5+B5/24/60/60 |
| C6 | =A6+B6/24/60/60 |
| C7 | =A7+B7/24/60/60 |
Thanks. Since, to add with secs.millisecs (set as number in Format cells), modified the formula as C1+D1/(24*60*60) which worked.