Time calculation (TimeXnumber)

Solved/Closed
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Feb 17, 2015 at 01:32 AM
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Feb 17, 2015 at 11:08 PM
Hello,
i want calculate the salary of workers like the following example.

worker No.1 salary/hour 1$
working hours this week 3:45 (3 hours and 45 minutes)
the answer must be 3.75$ but i want a formula for this,
i will appreciate your answers as always.

2 replies

Blocked Profile
Feb 17, 2015 at 07:53 AM
Hello,

I've quickly made this up for you.

You will need to format the columns so they change to currency.



If at first you don't succeed; call it version 1.0
1
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Feb 17, 2015 at 11:07 PM
thanks for your reply
0
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 25
Feb 17, 2015 at 03:25 PM
The number of hours needs to be converted to decimal hours so that the calculation can work.
1
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Feb 17, 2015 at 11:08 PM
thanks Rayh for your replay.
0