ExcelBanter - Time Format Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Time Format Question (https://www.excelbanter.com/excel-worksheet-functions/33859-time-format-question.html)

C A

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

Bob Phillips

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

All times are GMT +1. The time now is 10:47 PM.