Help with excel Please

brian ireland · 19-09-2010 09:18PM #1

I know this is not an after hours type topic but i done a search and cant find where to post this.
This probably the best place because so many different type of people visit here and may be good at excel.
I need help seriously fast,I need this sh*t for tomorrow.
I need to figure out how to calculate hours worked in excel. So I need to enter say start time 07:00 end time 15:00 and then take away 1 hour. I want the cell with the sum in it to equal to how many hours worked -1 hour breaks. so say thats 8 hours -1 so the cell will have 7 in it.

Please help before i go mad!!

Cookie_Monster · 19-09-2010 09:19PM

have you tried turning if off and on again?

epgc3fyqirnbsx · 19-09-2010 09:20PM

Have you tried going on the dole?

Run_to_da_hills · 19-09-2010 09:20PM

EXCELlent thread.

alwaysadub · 19-09-2010 09:20PM

Use a calculator

Cookie_Monster · 19-09-2010 09:20PM

a1 is start time (7)
a2 is end time (15)
a3 = a2-a1-1

=15-7-1
=7

QED

koppy · 19-09-2010 09:21PM

Cookie_Monster wrote: »

have you tried turning if off and on again?

:D

Scuid Mhór · 19-09-2010 09:21PM

brian ireland wrote: »

I know this is not an after hours type topic but i done a search and cant find where to post this.
This probably the best place because so many different type of people visit here and may be good at excel.
I need help seriously fast,I need this sh*t for tomorrow.
I need to figure out how to calculate hours worked in excel. So I need to enter say start time 07:00 end time 15:00 and then take away 1 hour. I want the cell with the sum in it to equal to how many hours worked -1 hour breaks. so say thats 8 hours -1 so the cell will have 7 in it.

Please help before i go mad!!

i wish i could help you. i'd never leave a wounded soldier on the battlefield.

but i'm not a soldier... never was.

Gran Hermano · 19-09-2010 09:21PM

www.writeon.ie

starbelgrade · 19-09-2010 09:23PM

Just use a calculator.

brian ireland · 19-09-2010 09:25PM

starbelgrade wrote: »

Just use a calculator.

I need a spread sheet:eek: i have to enter times for 7 days for 50 people!!! AHHH!!

brian ireland · 19-09-2010 09:28PM

Monserrat Obedient Suds wrote: »

Have you tried going on the dole?

Just came for there!!!

I cant go back so soon. HElp

alwaysadub · 19-09-2010 09:28PM

brian ireland wrote: »

I need a spread sheet:eek: i have to enter times for 7 days for 50 people!!! AHHH!!

And you left it till half 9 on Sunday night without actually knowing what to do before starting it.
Good man.

dvpower · 19-09-2010 09:29PM

brian ireland wrote: »

I need a spread sheet:eek: i have to enter times for 7 days for 50 people!!! AHHH!!

But you've got 'till tomorrow to do it.

Anyway, Cookie_Monster already told you how.

(It's a good thing you know how to use Internet Explorer, otherwise you'd be in deep trouble)

Agricola · 19-09-2010 09:29PM

Click the dancing paper clip in the corner. He wants to help you.

Earthhorse · 19-09-2010 09:29PM

brian ireland wrote: »

Just came for there!!!

I cant go back so soon. HElp

Read the thread again.

Lizzzard · 19-09-2010 09:29PM

haha it's like not doing your homework on friday when you get home from school, and leaving it til last thing on Sunday evening, good luck dcikhead

Tony10 · 19-09-2010 09:30PM

i'll work it out for you in a few mins.just waiting on excel to open up on home pc(dont have it on my laptop).

19-09-2010 09:32PM

Do you mean =(15-7)-1 ?

o1s1n · 19-09-2010 09:32PM

Autosum?

phasers · 19-09-2010 09:33PM

ffs lrn2maths

strokemyclover · 19-09-2010 09:34PM

Your effort in trying to do this yourself sounds enough for me, I think your Excel is not working correctly for you - Try deleting your System32 folder

TheRiddler · 19-09-2010 09:34PM

Delete system 32.

starlit · 19-09-2010 09:34PM

Type an '=' in your cell and then click into your cell with 15:00, then subtract with your '-' and click into your cell with 7:00, press the enter key and that should bring up your answer? Be sure to check your cell settings that you can do this where there is an option for decimals, averages, figures with euros, accountancy figures that have similar ways to have figures sorted out.

starbelgrade · 19-09-2010 09:37PM

Bang your head off the keyboard.

brian ireland · 19-09-2010 09:39PM

Lizzzard wrote: »

haha it's like not doing your homework on friday when you get home from school, and leaving it til last thing on Sunday evening, good luck dcikhead

Thats nice!!! just finished a 12 hour day and start again at 6. please dont give me grief. i calling in the troops for help..

:D:D:D

Earthhorse · 19-09-2010 09:41PM

Have you tried doing this through Word?

-Corkie- · 19-09-2010 09:42PM

brian ireland wrote: »

Thats nice!!! just finished a 12 hour day and start again at 6. please dont give me grief. i calling in the troops for help.. :D:D:D

resserver.php?blogId=175&resource=computer%26angryman.jpg

Pace2008 · 19-09-2010 09:43PM

If 07:00 is in A2, and 15:00 is in A3, your formula will be:

=A3-A2-"1:00"

I'd custom format the formula cell as [h]:mm

And use some initiative in future, this is basic stuff (hint:Google).

brian ireland · 19-09-2010 09:43PM

TheRiddler wrote: »

Delete system 32.

Bad Boy;)

starbelgrade · 19-09-2010 09:44PM

brian ireland wrote: »

Thats nice!!! just finished a 12 hour day and start again at 6. please dont give me grief. i calling in the troops for help.. :D:D:D

*Sound of tiny violins*

Help with excel Please

Comments