You should enter it as time and change the formats.

Input
A1: 4:00 AM
A2: 10:30 AM
A3: 24*(A2-A1)

Format A1 and A2 as
hhmm
and format A3 as General or as a number

Result:
A1: 0400
A2: 1030
A3: 6.5

"demetri" wrote:

How do you make a formula that sais that an employee started work at 4am and
finished at 1030 am i need the answer to 6.5 hrs. The problem would read say
in cell a1 "0400" in cell a2 (1030) and then I want cell 3 to display the
amount of hrs as 6.5 not 6.3?