=A1*24, format as Number, not as Time (which Excel will do automatically)

--
Kind regards,

Niek Otten

"zyberdoc" wrote in message
...
Entering time in excel to create a time sheet 7.00am start 14.30 finish
would give a figure of 7.30 hrs as worked , actually 7.5 hrs is the hours
worked. How does one achieve this answer