how do i add seconds (time)?
assume you use integers for seconds thus entering them as 15 for 15 second
as opposed to 0:0:15 then just add them with SUM
=SUM(A1:A10)
where A1:A10 holds your seconds,
then use
=SUM(A1:A10)/86400
format as [hh]:mm:ss
--
Regards,
Peo Sjoblom
Portland, Oregon
"eufemistic" wrote in message
...
I need to add up seconds and also have those converted to minutes. I am
timing scenes of script. I have to note the seconds for each scene, and
then
tally up the time on a rolling basis, from scene to scene and have them
converted to minutes (as the time rolls). This particular script is less
than
one hour, but if it were an hour or more I would need to also have minutes
converted to hours as the time rolls. Any ideas? This is somewhat urgent.
Any
assistance you can offer wouldbe greatly appreciated.
Thanks!
-E
|