Percentage of time worked

[Simbor2]

Hi!
This is my first post here and I am sorry if the question has already been asked and answered. Couldn't find anything for this.
Anyways!
I can't figure out how to get the % total of hours worked. The formula for total is: =SUM(L85:R85) ,for example. How do I make that into percent if a the total of a work week is 40 hours?

 

[alansidman]

=S85/40 and then change the format to %

 

[Simbor2]

=S85/40 and then change the format to %

I've tried that and I get the result 1,67% which isn't correct.

 

[Simbor2]

=S85/40 and then change the format to %

If I fill the work week I get this in time format.

This in percent

 

[FormR]

Hi, you need to convert the 40 to a time, you can do that by dividing by the number of hours in a day.

So..

=S85/(40/24)

 

[Simbor2]

Hi, you need to convert the 40 to a time, you can do that by dividing by the number of hours in a day.

So..

=S85/(40/24)

Hi, thanks for helping.
Unfortunately that formula gives me this:

 

[FormR]

Hi, can you post some sample data that we can work with? Pictures do not help us to diagnose what is going on.

Book1
	L	M	N	O	P	Q	R	S	T
84	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Total	%
85	00:00	08:00	08:00	00:00	00:00	00:00	00:00	16:00	40%
86	08:00	08:00	08:00	08:00	08:00	00:00	00:00	40:00	100%
87	08:00	08:00	08:00	00:00	00:00	00:00	00:00	24:00	60%
Sheet1

Cell Formulas
Range	Formula
S85:S87	S85	=SUM(L85:R85)
T85:T87	T85	=S85/(40/24)

 

[Simbor2]

Hi, can you post some sample data that we can work with? Pictures do not help us to diagnose what is going on.

Hi! So sorry, it was a typo that made the misstake. What you said worked. Thank you so much!

 

[FormR]

That's great, thanks for letting us know