Calculate hours by just entering number of hours/minutes without a start end time

[eobrien]

Good Morning,

I want to just put in actual hours worked by site. So, if 5 and a half hours worked at one location 5.30 would be put in. If 5 hours and 15 minutes were worked somewhere 5.15 would be put under that site. I have tried different formatting to give me a sum/result that will compute to regular hours/minutes, but doesn't work. Actually, results don't give enough hours/minutes worked. For example at one site where 2 hours and 90 minutes + 5 hours and 10 minutes is resulting in 8 hours versus 8 hours and 40 minutes. I get it, that it's just putting minutes into whole numbers. I am sure this is an easy fix with formatting, but not coming up with it. Any assistance is appreciated. Thank you. E

 

[Fluff]

ays "this view file isn't supported in protective view"

Have a look here XL2BB Icons greyed out

Also from your image in post#7 you do not have the + sign in front of the range.

 

[Dave Patton]

A picture does not allow us to review your formulas.
Please also answer the questions!

Edit the following for your range
N.B. 5 hours and 50 minutes is 5.8333 hours

Time 2023.xlsm
	F	G	H	I	J
17	0.2	0	20
18	1	1	0
19	0.3	0	30
20	0.15	0	15
21	0.3	0	30
22	1	1	0
23	1	1	0
24	1	1	0
25	0.15	0	15
26		4	110
27			Hours	Minutes
28	4	110	5	50	5.833333333
29					5.833333333
30
2g

Cell Formulas
Range	Formula
G17:G25	G17	=INT(F17)
H17:H25	H17	=(F17-G17)*100
G26:H26	G26	=SUM(G17:G25)
F28	F28	=SUM(INT(F17:F25))
G28	G28	=SUM(MOD(F17:F25,1))*100
H28	H28	=F28+INT(G28/60)
I28	I28	=G28-60
J28	J28	=F28+INT(G28/60)+I28/60
J29	J29	=SUM(INT(F17:F25))+SUM(MOD(F17:F25,1))*100/60

 

[Dave Patton]

Your request stated " I want to just put in actual hours worked by site"

That is what the formula provides. I wasted time building another example that just confirms that the suggestions were correct.
50 minutes is not .5 of an hour.

 

[Fluff]

50 minutes is not .5 of an hour.

No, but that is what the OP said they wanted as per

if 5 and a half hours worked at one location 5.30 would be put in. If 5 hours and 15 minutes were worked somewhere 5.15 would be put under that site

 

[eobrien]

Your request stated " I want to just put in actual hours worked by site"

That is what the formula provides. I wasted time building another example that just confirms that the suggestions were correct.
50 minutes is not .5 of an hour.

My apologies, that my explanation wasn't sufficient & that I misunderstood what you presented. I am trying to pay a person appropriately and the HH:MM x Payrate is not computing correctly. I will go back to the drawing board. Again, apologies.

 

[Fluff]

Did you try putting the + sign in the formula you showed in your image from post#7?

 

[Dave Patton]

You stated "I am trying to pay a person appropriately and the HH:MM x Payrate is not computing correctly. "

What does this mean?
What calculation are you trying?

With a rate of 100 per hour 5 hours is 5*100=500
5 hours and .5 hours (30 min) is 5.5*100= 550.00
5 hours and .0833 hours (50 min) =5.8333*100 =583.33
=(5+50/60)*100=583.33

 

[Dave Patton]

Fluff's suggestion will also yield the correct answer.

Time 2023.xlsm
	E	F	G
15	Rate	$100.00	$583.33
16
17		0.2
18		1
19		0.3
20		0.15
21		0.3
22		1
23		1
24		1
25		0.15
2g

Cell Formulas
Range	Formula
G15	G15	=SUM(DOLLARDE(+F17:F25,60))*F15

 

[Fluff]

That will not give the correct answer, if the OP wants the result in the same format as the the data is entered. It will need to be as I posted.
The OP just needs to put the + sign back into the formula.