LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matt_hull1979
 
Posts: n/a
Default How do i enter minus hours in a spreadsheet?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating spreadsheet of Outlook emails [email protected] Excel Discussion (Misc queries) 3 January 9th 06 04:33 PM
Hyperlinking to Excel 2000 with a linked spreadsheet LDPitsy1970 Excel Discussion (Misc queries) 0 October 12th 05 02:31 PM
Spreadsheet merging problems Sam B Excel Worksheet Functions 0 September 19th 05 08:05 PM
comparing a value in a cell to see if it is higher than a number PK Excel Worksheet Functions 9 June 2nd 05 03:35 PM
Help! I am stuck calculating Days, Hours, Mins please help OB1 Excel Worksheet Functions 3 November 15th 04 05:17 PM


All times are GMT +1. The time now is 11:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"