adding times

[JJTwinCities]

I have a worksheet with a column of times that I would like to add
together. The times are written as 4:00, 3:30, :30, etc. I cannot
seem to add a couple of cells, as a test, or add the whole column of
times using auto sum.

I've tried formating the cells as "general", "time", or other options
using the Format /cells/number menus.

Any suggestions?

 

[JE McGimpsey]

I have a worksheet with a column of times that I would like to add
together. The times are written as 4:00, 3:30, :30, etc. I cannot
seem to add a couple of cells, as a test, or add the whole column of
times using auto sum.

I've tried formating the cells as "general", "time", or other options
using the Format /cells/number menus.

If the times are actually stored as times (rather than text), then using
=SUM(range) will work. Format the cells as tim, and if they will add to
more than 24 hours, use Format/Cells/Number/Custom... [h]:mm

The brackets tell the display engine not to roll over every 24 hours.

If the values are stored as Text, then copy an empty cell, select your
times, then choose Edit/Paste Special, selecting the Valuse and Add
radio buttons. Format as above.

 

[JJTwinCities]

I have a worksheet with a column of times that I would like to add
together. The times are written as 4:00, 3:30, :30, etc. I cannot
seem to add a couple of cells, as a test, or add the whole column of
times using auto sum.

I've tried formating the cells as "general", "time", or other options
using the Format /cells/number menus.

If the times are actually stored as times (rather than text), then using
=SUM(range) will work. Format the cells as tim, and if they will add to
more than 24 hours, use Format/Cells/Number/Custom... [h]:mm

The brackets tell the display engine not to roll over every 24 hours.

If the values are stored as Text, then copy an empty cell, select your
times, then choose Edit/Paste Special, selecting the Valuse and Add
radio buttons. Format as above.

I attempted your recommendations, but to no avail. I believe these
numbers
are translated into text, but your suggestion of copying and re-
formatting them
does not work.

 

[JE McGimpsey]

I attempted your recommendations, but to no avail. I believe these
numbers
are translated into text, but your suggestion of copying and re-
formatting them
does not work.

Did you format the cells as General or time first?

I didn't say to copy and reformat the numbers, I said to copy an EMPTY
cell, then select the cells with times and choose Edit/Paste Special,
selecting the Values and Add radio buttons.