Frank Freese

asked on

# Time Sheet Calcuation

Folks,

I need a little help on calculating time difference then multiplying that result times an hourly rate.

For example:

Start Time is 9:30 AM

End Time: 1:00 PM

Hours worked: 3.5

Hourly Rate: $40

Therefore, the amount to record to invoice = $87.50

I'm having a problem with my time subtraction to return 3.5 as number rather than 3.3 as time

I need a little help on calculating time difference then multiplying that result times an hourly rate.

For example:

Start Time is 9:30 AM

End Time: 1:00 PM

Hours worked: 3.5

Hourly Rate: $40

Therefore, the amount to record to invoice = $87.50

I'm having a problem with my time subtraction to return 3.5 as number rather than 3.3 as time

Try this

B2= end time

A2= start time

Thanks

*=TEXT(B2-A2,"h:mm")*B2= end time

A2= start time

Thanks

ASKER CERTIFIED SOLUTION

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

ASKER

Perfect

ASKER

thank you very much

See the example sheet to show how you can calculate this.

EE-time-pay.xlsx