HH:MM:SS



A storyline has length of scene in col D and running total in col F and
times are entered in seconds.

So:



Scene 1 B1 = 5 D1 = 00:00:05
(=B1)

Scene 2 B11 = 20 D11 = 00:00:25
(=B11+D1)

Scene 3 B21 = 55 D21 = 00:01:20
(=B21+D11)

Etc



Question 1

How should the cells be formatted?

Presumably "HH:MM:SS" or "MM:SS" if only minutes and seconds needed.



Question 2

Can the seconds be entered into col B simply as a numeral "5" or must they
be entered as "00:00:05"?



I have not needed to work with time for ages and I am getting into an awful
muddle!

Please help.



Francis Hookham