Link to home
Avatar of Frank Freese
Frank FreeseFlag for United States of America

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
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

Sounds like you're entering decimal values for time instead of hh:mm AM/PM

See the example sheet to show how you can calculate this.
EE-time-pay.xlsx
Try this =TEXT(B2-A2,"h:mm")

B2= end time
A2= start time

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Steven Harris
Steven Harris
Flag of United States of America image

Blurred text
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.
See Pricing Options
Start Free Trial
Avatar of Frank Freese

ASKER

Perfect
thank you very much