Excel Formula minutes convert to hours

Why not format the cells to a time format thus-
Format - cells - time - 37:30:55

This will give time in hours minutes and seconds that can be added

Sorry excell dont work like that. If you try to enter say 1hr 30min as 1.5
it trys to use it as a date function and displays 12:00:00 and if you try to
add times it treats them also as dates such that 12:00:00 + 12:00:00 =
0:00:00.

I use two columns and add one mod 60 etc.

Peter.



Excell does work like that! ie for a flight of 8hrs 57min you put 8:57
You have to use the format including seconds at the one for just hrs:min will
give you a false reading at higher values.
I have entered my logbook for over 600 flights using this method and it works
for me.

"OscarCVox" wrote in message
...
Why not format the cells to a time format thus-
Format - cells - time - 37:30:55

This will give time in hours minutes and seconds that can be added

Sorry excell dont work like that. If you try to enter say 1hr 30min as 1.5
it trys to use it as a date function and displays 12:00:00 and if you try
to
add times it treats them also as dates such that 12:00:00 + 12:00:00 =
0:00:00.

I use two columns and add one mod 60 etc.

Peter.



Excell does work like that! ie for a flight of 8hrs 57min you put 8:57
You have to use the format including seconds at the one for just hrs:min
will
give you a false reading at higher values.
I have entered my logbook for over 600 flights using this method and it
works
for me.


OK try summing a few time that when added are greater than 24 hrs. Or put a
time in of 45hrs 36mins and see what it does then.

Peter

"Peter Seddon" wrote in message
OK try summing a few time that when added are greater than 24 hrs. Or put
a
time in of 45hrs 36mins and see what it does then.

Peter


Peter,

I have been watching this thread and thought I would see what happens on my
computer using Excel as delivered in Office 2000.

Using the format Category of "Time" and the Type "37:20:55" I entered 12:22,
14:38, 72:14 and the above mentioned 45:36. Summing this column gave an
accurate total of 144:50:00.

What version of Excel are you using?

Wayne,
http://www.soaridaho.com/

Wayne Paul wrote:
Using the format Category of "Time" and the Type "37:20:55" I entered 12:22,
14:38, 72:14 and the above mentioned 45:36. Summing this column gave an
accurate total of 144:50:00.

What version of Excel are you using?

I tried this in Excel 97 (I'm too cheap to upgrade). The key seems to
be using the "37:30:55" time format in the Format Cells dialog. If any
other time format is used, the values are interpreted as time of day,
and wrap around at 24 hours.

Marc

"Marc Ramsey" wrote in message
. com...
Wayne Paul wrote:
Using the format Category of "Time" and the Type "37:20:55" I entered
12:22,
14:38, 72:14 and the above mentioned 45:36. Summing this column gave an
accurate total of 144:50:00.

What version of Excel are you using?

I tried this in Excel 97 (I'm too cheap to upgrade). The key seems to be
using the "37:30:55" time format in the Format Cells dialog. If any other
time format is used, the values are interpreted as time of day, and wrap
around at 24 hours.

Marc

I'm on excel 2003 and the 37:30:55 time format aint available to me.

Peter.

Peter Seddon wrote:
"Marc Ramsey" wrote in message
I tried this in Excel 97 (I'm too cheap to upgrade). The key seems to be
using the "37:30:55" time format in the Format Cells dialog. If any other
time format is used, the values are interpreted as time of day, and wrap
around at 24 hours.

Marc

I'm on excel 2003 and the 37:30:55 time format aint available to me.

It is 99.9% likely that there is an equivalent in Excel 2003, as
Microsoft never takes code out, they just add new features that nobody
uses 8^). There are probably at least three distinct hh:mm:ss entries
in the format dialog, one should work.

Marc

"Wayne Paul" wrote in message
...

"Peter Seddon" wrote in message
OK try summing a few time that when added are greater than 24 hrs. Or put
a
time in of 45hrs 36mins and see what it does then.

Peter


Peter,

I have been watching this thread and thought I would see what happens on
my
computer using Excel as delivered in Office 2000.

Using the format Category of "Time" and the Type "37:20:55" I entered
12:22,
14:38, 72:14 and the above mentioned 45:36. Summing this column gave an
accurate total of 144:50:00.

What version of Excel are you using?

Wayne,
http://www.soaridaho.com/



I'm on 2003 but the format you selected is for mins and sec + one dec place
of secs not hrs and mins

Peter.

Excell does work like that! ie for a flight of 8hrs 57min you put 8:57
You have to use the format including seconds at the one for just hrs:min
will
give you a false reading at higher values.
I have entered my logbook for over 600 flights using this method and it
works
for me.


OK try summing a few time that when added are greater than 24 hrs. Or put a
time in of 45hrs 36mins and see what it does then.

Peter

Entered it, added it, it worked!!!
Read and try it