Adding hrs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

demetri - 18 Nov 2005 22:51 GMT

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?

Reply to this Message

Sloth - 18 Nov 2005 23:02 GMT

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

> 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?

Reply to this Message

demetri - 18 Nov 2005 23:10 GMT

> You should enter it as time and change the formats.
>
[quoted text clipped - 16 lines]
> > 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!

Reply to this Message

Bob Phillips - 18 Nov 2005 23:25 GMT

Try

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

and format as general

Signature

HTH

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

Reply to this Message