ExcelBanter - Excel

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel (https://www.excelbanter.com/excel-discussion-misc-queries/195255-excel.html)

Sharon

Excel

My husband is preparing a time sheet for his red cross duty hours but he
can't change the time results i.e. 03:30 to show 03.5 can anyone help

ldiaz

Excel

try this..

A B
1 3:30 =(A1-INT(A1))*24

Thanks

--
Lorenzo DÃ*az
Cad Technician

"Sharon" wrote:

My husband is preparing a time sheet for his red cross duty hours but he
can't change the time results i.e. 03:30 to show 03.5 can anyone help

All times are GMT +1. The time now is 11:40 PM.