Excel Spreadsheet Help

JBW1366 | 22:04 Sun 17th Jul 2022 | Technology

21 Answers

I’m trying to do a spreadsheet for work and it’s for staff holidays so I have four columns with column C the amount in hours they’ve asked for and column D their remaining leave - is there a sim for it to work it out automatically? All the way down the more they ask for? I need to use this some for petty cash sheet as well. I’ve been looking for ages. Thanks in advance

Photos From Mobile Phone To Pc

Adding Googlemail Acc. To Laptop, W10

Answers

21 to 21 of 21

First Previous 1 2

Tuvok

Best Answer

Working on a 1 person per sheet system Column headings are A Name B Department C Entitlement D From E To F No. Hours G Balance First Row (2nd row in spreadsheet) A Mickey Mouse B Disney C 100 D 21 July E 23 July F 2 G =sum(c2-f2) Second and subsequent rows G =sum(g2-f3) You then copy that formula into each row

08:39 Mon 18th Jul 2022

Go To Best Answer

Gettingonabit

Have you managed to create the spreadsheet?

21 to 21 of 21

First Previous 1 2

Do you know the answer?