| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
