Display and calc of time formatted colum

[Bazza]

Errr. I need a bit of help from someone please.

I'm using Office XP and in Excel, what I
want to do is create a column of time(s).

The time is displayed as - mm:ss:xxx - so that e.g.
3:29:917 (means) 3 min, 29 secs, and .917 of a sec

A. Is the format achievable as a display and if so, how?
B. Can the numbers be aggregated (summed)

 

[Norman Harker]

Hi Bazza!

Format mm:ss.000

But watch your data entry is 00:03:29.917

You can aggregate in the normal way =A1+B1+C1

However, if you don't want minutes to change to hours after you get to
60 use:

[mm]:ss.000

Similarly if you don't want hours to clock over to days use:

[hh]:mm:ss.000
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bazza]

Hi Bazza!

Format mm:ss.000

But watch your data entry is 00:03:29.917

You can aggregate in the normal way =A1+B1+C1

Thanks for that Norman.
Question is, (now) how.
From format/cells/number/ (time) (custom) (something else) ?
I've tried most of the options and must have missed the most crucial one

 

[Bazza]

Thanks for that Norman.
Question is, (now) how.
From format/cells/number/ (time) (custom) (something else) ?
I've tried most of the options and must have missed the most crucial one

Belay that. - Just worked it out. Thanks

 

[Frank Kabel]

Hi
- goto 'Format - Cells - number'
- choose the category 'custom'
- manually enter the format in the textbox on the right side

 

[Norman Harker]

Hi Frank!

Have those 1000 camels arrived yet? I've sent the two bricks <vbg>

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi Frank!

Have those 1000 camels arrived yet? I've sent the two bricks <vbg>

Good morning Norman
unfortunately not :-(
still waiting for them - but I'll take the bricks nethertheless after
yesterdays Champion League's result <ebg>

Frank