Time calculation (TimeXnumber) [Solved/Closed]

Report
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
-
ArashMan
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
-
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

Posts
2508
Registration date
Sunday October 5, 2008
Status
Member
Last seen
December 23, 2019
443
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4050 users have said thank you to us this month

ArashMan
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
thanks for your reply
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
The number of hours needs to be converted to decimal hours so that the calculation can work.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4050 users have said thank you to us this month

ArashMan
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
thanks Rayh for your replay.