OT Kind of: Dealing with minutes and hours in Excel Ride Diary?

I started keeping a ride diary in Excel this year, but I've never been able
to figure out how to get it to work with hours:minutes:seconds.

Is there a function, format, or some other easy way to get it to work in
base 6 instead of base 10 (I think that's what you call it). In other
words, when adding two cells with a value of 45 minutes in each to get a
total of 1:30? I have one area where that divides the number of hours I've
spent on the bike for the month by the numbers of days in the month. I'm
tired of seeing 1.25 instead of 1:15.

Thanks

..., when adding two cells with a value of 45 minutes in each to get a
total of 1:30? I have one area where that divides the number of hours I've
spent on the bike for the month by the numbers of days in the month. I'm
tired of seeing 1.25 instead of 1:15.


Yes, it's the proper cell format that you need for all cells
involved in your calculations.

Format all time cells for category "Time", type "37:30:55".

For the time, always enter as "h:mm:ss" - e.g., for 45 minutes enter
0:45:00.

So I can divide a week's "8:10:00" by 7 and get 1:10:00.

But we really should be riding rather than playing
with stinkin' spreadsheets.

-Joel

I'm using Excel 2004 for mac, but I was able to do the same in Excel 98,
but the format category/type may differ.
I imagine the windoze version of excel works the same/similar.

On Wed, 25 Aug 2004 00:47:46 GMT, J Brown
wrote:


..., when adding two cells with a value of 45 minutes in each to get a
total of 1:30? I have one area where that divides the number of hours I've
spent on the bike for the month by the numbers of days in the month. I'm
tired of seeing 1.25 instead of 1:15.


Yes, it's the proper cell format that you need for all cells
involved in your calculations.

Format all time cells for category "Time", type "37:30:55".

For the time, always enter as "h:mm:ss" - e.g., for 45 minutes enter
0:45:00.

So I can divide a week's "8:10:00" by 7 and get 1:10:00.

But we really should be riding rather than playing
with stinkin' spreadsheets.

-Joel

I'm using Excel 2004 for mac, but I was able to do the same in Excel 98,
but the format category/type may differ.
I imagine the windoze version of excel works the same/similar.

Dear Joel,

Hmmm . . . what a nice format. Maybe I need to consider
upgrading my 1994 MS-DOS Lotus.

Until then, I just add a column that totes up hours,
minutes, and seconds as raw seconds--651,734 so far this
year.

Maybe this is how fixed-gear people feel when they listen to
indexed-shifting discussions?

Carl Fogel

I've got a Windows spreadsheet that does time arithmetic.

If you want to take a look, flip me an email at
and I'll send it to you.

..., when adding two cells with a value of 45 minutes
in each to get a
total of 1:30? I have one area where that divides the number of hours I've
spent on the bike for the month by the numbers of days in the month. I'm
tired of seeing 1.25 instead of 1:15.

On Wed, 25 Aug 2004 00:47:46 GMT, J Brown
wrote:
Yes, it's the proper cell format that you need for all cells
involved in your calculations.
Format all time cells for category "Time", type "37:30:55".
For the time, always enter as "h:mm:ss" - e.g., for 45 minutes enter
0:45:00.
So I can divide a week's "8:10:00" by 7 and get 1:10:00.
But we really should be riding rather than playing
with stinkin' spreadsheets.

wrote:
Hmmm . . . what a nice format. Maybe I need to consider
upgrading my 1994 MS-DOS Lotus.
Until then, I just add a column that totes up hours,
minutes, and seconds as raw seconds--651,734 so far this
year.
Maybe this is how fixed-gear people feel when they listen to
indexed-shifting discussions?


There are valid reasons - concatenation comes to mind- to
keep using Lotus. Graphing is better in Excel but neither is
superior overall IMHO.


--
Andrew Muzi
www.yellowjersey.org
Open every day since 1 April, 1971

wrote:
Maybe this is how fixed-gear people feel when they listen to
indexed-shifting discussions?

if by that you mean pity, then yes.
--
david reuteler