| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change regular 24 hour format to military time in excel | Excel Worksheet Functions | |||
| Excel 2003- Charts- date and time format on x-axis of XY chart | Charts and Charting in Excel | |||
| Excel 2003 can you change the header date format? | Excel Discussion (Misc queries) | |||
| Where can I change the footer &[Date] format in Excel 2003? | Setting up and Configuration of Excel | |||
| Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) | |||
Linear Mode
