Excel 2003 -- how do I change a time format

[Carmilla]

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.

 

[T. Valko]

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

 

[Carmilla]

Thank you T. Valko -- worked great!

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

 

[T. Valko]

You're welcome. Thanks for the feedback!