Using Hours Entry to calculate in Total Hours

webking · Mar 17th, 2002, 12:38 PM

I have an Excel Sheet in which the hours of workers are input. This input is made 2 times , 1 when the work comes in the company and second when he leaves the Company.
How i can make excel to calculate total hours of a worker. Means

Workers IN OUT TOTAL HOURS

John 8:30A.M. 5:30P.M. 9

Please guide the procedure in steps.
thankyou.

Mudface · Mar 17th, 2002, 12:44 PM

If your total hours are in, say D1, Time in in B1 and Time out in C1, enter the following in D1: -

=C1-B1

Click on Format-Cells and select Custom. In the Type box, type in [hh]:mm. HTH.

webking · Mar 17th, 2002, 03:51 PM

thanks a Lot, your reply really helped me how i can vote for your name on this forum.

webking · Mar 17th, 2002, 04:54 PM

Mudface ,
Your post has helped me but the problem is i want to calculate the salary of each work. For this the method u have suggested is not working properply.

As after the total hours are calculate for a worker , his salary calculation includes rate per hour multipled by total hours and subtracting any advance money if taken by him. If i do this the result which is coming is not in Numbers , i have tried formatting the cell but no use.

Aladin Akyurek · Mar 17th, 2002, 05:10 PM

Quote:

On 2002-03-17 15:54, webking wrote:
Mudface ,
Your post has helped me but the problem is i want to calculate the salary of each work. For this the method u have suggested is not working properply.

As after the total hours are calculate for a worker , his salary calculation includes rate per hour multipled by total hours and subtracting any advance money if taken by him. If i do this the result which is coming is not in Numbers , i have tried formatting the cell but no use.

Lets say that you have total hours in A1 and you want to multiply it with $5.00 (a hour rate)

In B1 enter:

=(A1*24)*5

Format B1 as General.

Aladin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 17th, 2002, 12:38 PM	#1
webking New Member Join Date: Mar 2002 Posts: 21	I have an Excel Sheet in which the hours of workers are input. This input is made 2 times , 1 when the work comes in the company and second when he leaves the Company. How i can make excel to calculate total hours of a worker. Means Workers IN OUT TOTAL HOURS John 8:30A.M. 5:30P.M. 9 Please guide the procedure in steps. thankyou.

Mar 17th, 2002, 12:44 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	If your total hours are in, say D1, Time in in B1 and Time out in C1, enter the following in D1: - =C1-B1 Click on Format-Cells and select Custom. In the Type box, type in [hh]:mm. HTH.

Mar 17th, 2002, 03:51 PM	#3
webking New Member Join Date: Mar 2002 Posts: 21	thanks a Lot, your reply really helped me how i can vote for your name on this forum.

Mar 17th, 2002, 04:54 PM	#4
webking New Member Join Date: Mar 2002 Posts: 21	Mudface , Your post has helped me but the problem is i want to calculate the salary of each work. For this the method u have suggested is not working properply. As after the total hours are calculate for a worker , his salary calculation includes rate per hour multipled by total hours and subtracting any advance money if taken by him. If i do this the result which is coming is not in Numbers , i have tried formatting the cell but no use.