Excel/Google Sheets

[Jev]

So I can use Excel but the formulas are just way too complicated for my little brain.

Looking for some help. (not a big job)

 

[Seanofsmeg]

What is it your looking?

 

[Jev]

What is it your looking?

Looking to just be able to write my hours each day for work. it then times that by my hourly wage, then each week (paid weekly) add it all up -20% tax and give me a total

 

[Seanofsmeg]

no worries ill whip that up

 

[StormHero]

So I can use Excel but the formulas are just way too complicated for my little brain.

Looking for some help. (not a big job)

Always knew u had a little brain, anyways its pretty easy, if Sean ain't done it for u, I'll sort u out.

 

[Martyn]

i already use something, but interested to see what @Seanofsmeg or @StormHero makes lol

 

[Seanofsmeg]

haha sorry to dissapoint @Martyn but nothing fancy!

@Jev behold my 20 mins of excel..nesss.... Nothing great but should do the trick. Wasn't sure when your weeks run from and to? Does your pay weeks run from Mon-Sun? Let me know and ill update remainder of July. Stuck a 2nd tab on with just 7 days on it that can update to your liking if the running month doesn't tickle your fancy. Should be able to just drag and repeat the forumlas for month / day and copy for calculating weekly pay / tax. Just updated hourly rate and hours worked. Hope it helps some

 

[Jev]

So:

Get paid on fridays.

Week runs Friday - Thursday at midnight

Week in hand

 

[Seanofsmeg]

@Jev - Fri-Thurs format (that 2nd tab you could just keep copying and pasting and re-using if didnt want the long running months on 1st tab)

 

[Jev]

@Jev - Fri-Thurs format (that 2nd tab you could just keep copying and pasting and re-using if didnt want the long running months on 1st tab)

Thank you <3

 

[Martyn]

I use something like this on sheets atm, as my starts/finish time vary, needed quick way to edit times, problem is the sheet phone app is utter ****.