| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Time Format Question
I'm working on creating a weekly time sheet log. I have the formulas all set
up, but the total times need to be formated for quarter hours. (Where I need it to show "7.5" it shows "7.30") Thanks, Cynthia |
|
#2
|
|||
|
|||
|
You would have to convert to decimal hours for that, by multiplying by 24.
-- HTH Bob Phillips "C A" wrote in message ... I'm working on creating a weekly time sheet log. I have the formulas all set up, but the total times need to be formated for quarter hours. (Where I need it to show "7.5" it shows "7.30") Thanks, Cynthia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you format cells by time? | Excel Discussion (Misc queries) | |||
| How to format elapsed time for swimming scores | Charts and Charting in Excel | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| adding military time format | Excel Discussion (Misc queries) | |||
| Subtracting time in date format | Excel Worksheet Functions | |||
Linear Mode
