If times are entered as numbers ( 5, 20,35) in column B
Then D1 need =TIME(,,B1)
D11 needs =D1+TIME(,,B11)
Yes, format as HH:MM:SS
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Francis Hookham" wrote in message
...
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