Time calculation (TimeXnumber)

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


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
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.
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
thanks Rayh for your replay.