Adding hrs
 

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?

Adding hrs
 

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?

Adding hrs
 

"Sloth" wrote:

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?

Thank you!

Adding hrs
 

Try

=INT(A2/100)+MOD(A2,100)/60-INT(A1/100)+MOD(A1,100)/60

and format as general

--

HTH

RP
(remove nothere from the email address if mailing direct)


"demetri" wrote in message
...
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?