times

Pie4Weebl · Newbie Joined: 10 Nov 2007 Posts: 2

Quick question. I have a column of times, most of them are 10 or 15 seconds and I like them to just appear as 10 or 15. So when I enter a time over a minute the cell displays ### and I would like it to just show 1:00. How can I do this?

Also when printing how can I get cell borders to be displayed?

David · Posted: Sat Nov 10, 2007 11:39 am Post subject:

Increase the cell width to accommodate the wider statement. You have to have cells formatted as you want, of course. Personally, I'd pre-format the column as text if you don't want the units to show, and are not doing numerical calculations.

David.

Pie4Weebl · Newbie Joined: 10 Nov 2007 Posts: 2

The cell width is wide enough. When I click on the cell with the ### in the bar it displays 01:00:00 AM, and I don't want my 1:00 changed into that.

acknak · Posted: Sat Nov 10, 2007 2:00 pm Post subject:

1) Select the cells
2) Format > Cells > Numbers
3) In the "Format code" box, enter: [>0.0006945][M]:SS;[S]

That will show all your times simply as a number of seconds, or minutes:seconds if the time is more than 60 seconds.

You should also be aware that you must still enter the times as H:M:S--so a time of 15 seconds has to be entered as "0:0:15". I find that extremely inconvenient. Also, the times are displayed in the formula bar as a clock time: "12:00:15 AM", which is very confusing.

Because of that, I often use a decimal number of seconds for such time intervals.