Excel 2003 -- how do I change a time format

  • Thread starter Thread starter Carmilla
  • Start date Start date
C

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.
 
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
 
Thank you T. Valko -- worked great!

T. Valko said:
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
Click to expand...
 
Back
Top