how do you add times together to give a total time?
in [General]
|
Prev: Inserting pictures into Excel Sheet at a particular size
Next: How do I get a cell to auto change red when a certain numbe is ent
From: cmt on 24 Feb 2010 20:03 I want to add together a column of times on telephone calls.
From: Pete_UK on 24 Feb 2010 20:13
If those times are in Excel time format, then you can just SUM them and set the format of that cell as appropriate, maybe [mm]:ss - the square brackets instructs Excel not to wrap the number of minutes at 60 into hours, so that 1 hour and 30 minutes would show as 90:00 instead of 1:30:00. If the duration is in seconds, then you could have a formula like this: =SUM(S2:S1000)/60/60/24 with the cell formatted as time. Hope this helps. Pete On Feb 25, 1:03 am, cmt <c...(a)discussions.microsoft.com> wrote: > I want to add together a column of times on telephone calls. |