All Questions
2
questions
0
votes
2
answers
447
views
converting numbers into timecode in Excel
I have a column with a bunch of two 4 digits.
1354 1356
1402 1421
1431 1452
1532 1546
... and so on
I've been trying to convert these to look more like
13:54 ~ 13:56
14:02 ~ 14:21
14:31 ~ 14:52
...
3
votes
5
answers
39k
views
Convert Timestamp 00:00:00.000 into total seconds AND milliseconds
I have the problem that I am left with a timestamp that reads like: 00:02:02.300 meaning: hours - minutes - seconds - milliseconds.
and need to desperately convert it to total seconds. That is tricky ...