Excel 2003 -- how do I change a time format
 

I have tied together excel sheets by adding times hh.mm. For example: fomat
is 3:30 -- 3 hours and thirty minutes. I want to change the format to read
3.5 -- the hours and then in 1/4 increments.

Excel 2003 -- how do I change a time format
 

I assume this means you want to round to the nearest quarter hour and
convert the time value to a decimal value . Try something like this:

=ROUND(SUM(A2:A10)*24/0.25,0)*0.25

Format as General or Number

--
Biff
Microsoft Excel MVP


"Carmilla" wrote in message
...
I have tied together excel sheets by adding times hh.mm. For example:
fomat
is 3:30 -- 3 hours and thirty minutes. I want to change the format to
read
3.5 -- the hours and then in 1/4 increments.

Excel 2003 -- how do I change a time format
 

Thank you T. Valko -- worked great!

"T. Valko" wrote:

I assume this means you want to round to the nearest quarter hour and
convert the time value to a decimal value . Try something like this:

=ROUND(SUM(A2:A10)*24/0.25,0)*0.25

Format as General or Number

--
Biff
Microsoft Excel MVP


"Carmilla" wrote in message
...
I have tied together excel sheets by adding times hh.mm. For example:
fomat
is 3:30 -- 3 hours and thirty minutes. I want to change the format to
read
3.5 -- the hours and then in 1/4 increments.

Excel 2003 -- how do I change a time format
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Carmilla" wrote in message
...
Thank you T. Valko -- worked great!

"T. Valko" wrote:

I assume this means you want to round to the nearest quarter hour and
convert the time value to a decimal value . Try something like this:

=ROUND(SUM(A2:A10)*24/0.25,0)*0.25

Format as General or Number

--
Biff
Microsoft Excel MVP


"Carmilla" wrote in message
...
I have tied together excel sheets by adding times hh.mm. For example:
fomat
is 3:30 -- 3 hours and thirty minutes. I want to change the format to
read
3.5 -- the hours and then in 1/4 increments.