Previous Topic Next Topic

Time calculation (TimeXnumber)

Solved/Closed
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Feb 17, 2015 at 01:32 AM
ArashMan Posts 38 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.
Related:

2 responses

Answer 1 / 2
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
ArashMan Posts 38 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
Answer 2 / 2
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Feb 17, 2015 at 03:25 PM
The number of hours needs to be converted to decimal hours so that the calculation can work.
ArashMan Posts 38 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.

Similar discussions

The system time is invalid
LeonardPromise -
Anonymous User -

5 responses