Help with excel Please

brian ireland

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

have you tried turning if off and on again?

epgc3fyqirnbsx

Have you tried going on the dole?

Run_to_da_hills

EXCELlent thread.

alwaysadub

Use a calculator

Cookie_Monster

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

=15-7-1
=7

QED

koppy

Cookie_Monster wrote: »

have you tried turning if off and on again?

:D

Scuid Mhór

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

www.writeon.ie

starbelgrade

Just use a calculator.

brian ireland

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

Monserrat Obedient Suds wrote: »

Have you tried going on the dole?

Just came for there!!!

I cant go back so soon. HElp

alwaysadub

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

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

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

Earthhorse

brian ireland wrote: »

Just came for there!!!

I cant go back so soon. HElp

Read the thread again.

Lizzzard

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

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).

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

o1s1n

Autosum?

phasers

ffs lrn2maths

strokemyclover

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

Delete system 32.

starlit

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

Bang your head off the keyboard.

brian ireland

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

Have you tried doing this through Word?

-Corkie-

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

Pace2008

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

TheRiddler wrote: »

Delete system 32.

Bad Boy;)

starbelgrade

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*

Zen65

Cookie_Monster wrote: »

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

=15-7-1
=7

QED

The problem Cookie friend is that if the employee starts before lunchtime it's OK to deduct an hour, but if he starts after lunchtime it isn't. The formula needs to be smart enough to determine whether or not lunch is to be deducted.


And yes, Mr Ireland now knows this is a very strange place to ask for serious help!

Cheers,

Z

Ziboo

Like this?

http://www.mediafire.com/?ep5l8vnn6rchawq

Quazzie

Zen65 wrote: »

The problem Cookie friend is that if the employee starts before lunchtime it's OK to deduct an hour, but if he starts after lunchtime it isn't. The formula needs to be smart enough to determine whether or not lunch is to be deducted.


And yes, Mr Ireland now knows this is a very strange place to ask for serious help!

Cheers,

Z

Easy
A1=09
A2=13
A3=14
A4=19
A5="=(A2-A1)+(A4-A3)

If they weren't in before lunch then A1 and A2 are zero

Lu Tze

Zen65 wrote: »

The problem Cookie friend is that if the employee starts before lunchtime it's OK to deduct an hour, but if he starts after lunchtime it isn't. The formula needs to be smart enough to determine whether or not lunch is to be deducted.


And yes, Mr Ireland now knows this is a very strange place to ask for serious help!

Cheers,

Z

An if statement will do that

brian ireland

Thanks for the PM lads and ladies. Think i have it sorted