Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use Excel with times which are negatives?
e.g.
I work 35 hours a week, 7 x 5 days. Any time over 7h per day is flex time. Any less than 7 is negative flex time. I need to calculate daily my running flex time. Flex time needs to be both positive and negative and displayed in hh,mm. My cycle runs 4 weekly. Ta! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use Excel with times which are negatives?
You can change the settings under toolsoptionscalculation to 1904 date
system that will allow negative times, note that all dates will get 1462 days added to them so if you use this make sure you convert the dates back by putting 1462 in a cell, format the cell as date and copy it, select the dates you want to change back and do editpaste special and select add. You can also convert the times to decimal times and do the calculations, if you multiply excel times with 24 and format as general or number you will get decimal times -- Regards, Peo Sjoblom http://nwexcelsolutions.com "John_mitch" wrote in message ... e.g. I work 35 hours a week, 7 x 5 days. Any time over 7h per day is flex time. Any less than 7 is negative flex time. I need to calculate daily my running flex time. Flex time needs to be both positive and negative and displayed in hh,mm. My cycle runs 4 weekly. Ta! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I get Excel 2002 to add times together? | Excel Discussion (Misc queries) | |||
How can i add times in Excel? | Excel Discussion (Misc queries) | |||
Adding/Averaging Times in Excel | Excel Discussion (Misc queries) | |||
How do I duplicate a sheet 20 times in an excel spreadsheet | Excel Worksheet Functions |