Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have seen a previous post from earlier this month on a similar subject
which didn't really answer my question. I have a spreadsheet which i am using as a new overtime form for my office. Staff will enter their hours worked over their daily contracted hours, and it adds it up. however some staff take the extra time off in lieu, for example on the following day and i would like for them to be able to enter 3:00 on one day and -1:00 the next (for example) to give the total 2:00. the custom format i currently have for the date (which i borrowed from another spreadsheet we use) is [h]:mm_:_0_0 Is it possible to create an entry for -hh:mm without having to add an extra box in which negative hours are entered to be deducted at the end? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating spreadsheet of Outlook emails | Excel Discussion (Misc queries) | |||
Hyperlinking to Excel 2000 with a linked spreadsheet | Excel Discussion (Misc queries) | |||
Spreadsheet merging problems | Excel Worksheet Functions | |||
comparing a value in a cell to see if it is higher than a number | Excel Worksheet Functions | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |