Category Archives: Answers to MS Office Excel

QUESTION: 005

Question: 005 (EXCEL)

Hi. I use an online app at work that calculates my hours worked per day but it is always going wrong.

Has anyone got a spreadsheet that I can use to keep a manual record ?
It needs to have Time in Time out, Time in Time out as we obviously log out at lunchtime.

It also needs to compare my daily total to the standard 7 hours per day to see if I am plus or minus each day.

Would be great if there is one that does it weekly and feeds into a monthly report as well for carry over at end of month. Can’t find anything suitable online.

Answers

Excel Formulae

Excel Formulae

CONTACT || REGISTER || ASK ME

QUESTION: 004

Question: 004 (EXCEL)

Hello, Kriti I’ve been searching for hours… I’m trying to freeze the top row AND freeze either the image OR the cells that I labeled (just for this inquiry).

When the user scrolls, I want either one to remain visible to the user. I plan on deleting whichever one I am not able to freeze.

Does anyone know how to accomplish this??

Answers

Split Window

Excel Split Window

CONTACT || REGISTER || ASK ME