Enter negative time

[kallebolja]

I'm making a timescheet and I want to enter negative time in a cell.
have changed to 1904 date system, but I can't enter negative time.
can't enter it like text because I want to do further calculations. An
to enter it in this format -"10:15" is to "complicated". Is there
way around

 

[Norman Harker]

Hi Kallebolja!

You could enter all of your negative times as positives then:

put -1 in a cell
Copy
select the cells you want to be negatived
Edit > Paste Special > Multiply
OK

Now format as time.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[kallebolja]

I can't do that, because I have a column with random positive time an
negative time and I want to add up this column. I have atteched th
file so that you can see. I will manualy transfer the result in colum
G to F - it' a flex-time account

Attachment filename: mars 2004.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45707

 

[Norman Harker]

Hi kellebolja!

Put a series of record numbers agains the times
Sort on the times so that all the negs are together
Select the negs
Apply the -1 Copy > Paste Special > Multiply
Re-sort on the record numbers

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Dave Peterson]

One more option.

Use a helper column:

Say column A contains the time value.
put +1 or -1 in Column B
In C1, put =a1*b1
(and drag down)

and sum column C.