Excel

[Sharon]

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]

try this..

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

Thanks