PDA

View Full Version : Excel



Yorkeyite
07-14-01, 09:19 AM
I wish to format time as a quantity on a spreadsheet not as a chronological period. Not even sure if this is the correct way to express this.

My problem is that I cannot show any shortfalls in time theoretically needed and time taken on jobs

ie 5 hours assessed, 7 hours taken therefore -2hour deficit

greEd
07-17-01, 01:25 PM
? are you talking about macros ?

Yorkeyite
07-18-01, 04:36 PM
No, formats.

Currently using [h]:mm and while using the sum function allows me to exceed 24hours as a total it still will not allow me to produce a negative result.

I need a format that allows me to do this

Yorkeyite
07-21-01, 05:29 AM
Received information from elsewhere

For those who are interested use the 1904date system (Tools/options)