Negative time formats (again)

[steve]

Hi

We have a worksheet which we use for a timesheet. The use
can carry over a negative figure each month. But we can not
get the negative time to work on the sheet.

We tried the 1904 format but it still did not work.

We are using Excel 2k for windows.
The formula we are using is [hh]:mm

any other help would be appreciated.

Thanks

Steve

 

[Norman Harker]

Hi Steve!

I've set the date system to 1904 using Tools > Options > Calculation
A1: =NOW()
A2: =A1 - 1/24
A3: = A2-A1
Returns: =01:00 (with time format [hh]:mm)

Try this and report back. If you have still got problems give an
example.

--
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.

 

[Norman Harker]

Hi Steve!

I should have said it returns -01:00

--
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.

Hi Steve!

I've set the date system to 1904 using Tools > Options > Calculation
A1: =NOW()
A2: =A1 - 1/24
A3: = A2-A1
Returns: =01:00 (with time format [hh]:mm)

Try this and report back. If you have still got problems give an
example.

--
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.

Hi

We have a worksheet which we use for a timesheet. The use
can carry over a negative figure each month. But we can not
get the negative time to work on the sheet.

We tried the 1904 format but it still did not work.

We are using Excel 2k for windows.
The formula we are using is [hh]:mm

any other help would be appreciated.

Thanks

Steve

 

[Guest]

Norm
Do you have any idea why negative times work in the 1904 system? I always thought you couldn't do negative times in Excel

Thanks
Mark Graesse
(e-mail address removed)

----- Norman Harker wrote: ----

Hi Steve

I should have said it returns -01:0

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

Hi Steve

I've set the date system to 1904 using Tools > Options > Calculatio

A1: =NOW(
A2: =A1 - 1/2
A3: = A2-A
Returns: =01:00 (with time format [hh]:mm

Try this and report back. If you have still got problems give a example
--

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

H

We have a worksheet which we use for a timesheet. The us

can carry over a negative figure each month. But we can no
get the negative time to work on the sheet

We tried the 1904 format but it still did not work
We are using Excel 2k for windows

The formula we are using is [hh]:m

any other help would be appreciated
Thank
Stev

 

[Guest]

I just saw the other string on this topic.

Steve,
It looks like the problem you are having is related to the way you type in the time. Excel doesn't seem to like it when you type in a hh:mm format with a negative sign in front of it. The format you use to type is independent from the cell format. You will have to enter the value as a decimal portion of a day, or use some type of formula as Norman has suggested. If you want to enter 25 minutes you could use the formula:

=-25/60/24

All you need to do is adjust the 25 to the number of minutes you need.

Could you instead enter this number as a positive and then change whatever formula referes to this value?

Hope this helps,
Mark Graesser
(e-mail address removed)

----- Norman Harker wrote: -----

Hi Steve!

I should have said it returns -01:00

--
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.

Hi Steve!

I've set the date system to 1904 using Tools > Options > Calculation

A1: =NOW()
A2: =A1 - 1/24
A3: = A2-A1
Returns: =01:00 (with time format [hh]:mm)

Try this and report back. If you have still got problems give an example.
--

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.

Hi

We have a worksheet which we use for a timesheet. The use

can carry over a negative figure each month. But we can not
get the negative time to work on the sheet.

We tried the 1904 format but it still did not work.
We are using Excel 2k for windows.

The formula we are using is [hh]:mm

any other help would be appreciated.
Thanks
Steve

 

[Peo Sjoblom]

Or just

=-"00:25"



--

Regards,

Peo Sjoblom

I just saw the other string on this topic.

Steve,
It looks like the problem you are having is related to the way you type in

the time. Excel doesn't seem to like it when you type in a hh:mm format
with a negative sign in front of it. The format you use to type is
independent from the cell format. You will have to enter the value as a
decimal portion of a day, or use some type of formula as Norman has
suggested. If you want to enter 25 minutes you could use the formula:

=-25/60/24

All you need to do is adjust the 25 to the number of minutes you need.

Could you instead enter this number as a positive and then change whatever formula referes to this value?

Hope this helps,
Mark Graesser
(e-mail address removed)

----- Norman Harker wrote: -----

Hi Steve!

I should have said it returns -01:00

--
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.

Hi Steve!

I've set the date system to 1904 using Tools > Options >

Calculation
A1: =NOW()
A2: =A1 - 1/24
A3: = A2-A1
Returns: =01:00 (with time format [hh]:mm)

Try this and report back. If you have still got problems give an example.
--

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.

Hi
We have a worksheet which we use for a timesheet. The use
can carry over a negative figure each month. But we can not
get the negative time to work on the sheet.
We tried the 1904 format but it still did not work.
We are using Excel 2k for windows.
The formula we are using is [hh]:mm
any other help would be appreciated.
Thanks
Steve

 

[Norman Harker]

Hi Mark!

Why does 1904 system allow negative times?

Possibly because it came later. Recall that the 1900 date system is
flawed because it included 29-Feb-1900 when there was not a Leap Year
that year. The 1904 date system was meant to address that problem and
the designers probably chucked in negative times as an extra feature.
But I'm only guessing.

--
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.

Norm,
Do you have any idea why negative times work in the 1904 system? I

always thought you couldn't do negative times in Excel.

Thanks,
Mark Graesser
(e-mail address removed)

----- Norman Harker wrote: -----

Hi Steve!

I should have said it returns -01:00

--
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.

Hi Steve!

I've set the date system to 1904 using Tools > Options >

Calculation
A1: =NOW()
A2: =A1 - 1/24
A3: = A2-A1
Returns: =01:00 (with time format [hh]:mm)

Try this and report back. If you have still got problems

give an
example.

--

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.

Hi
We have a worksheet which we use for a timesheet. The use
can carry over a negative figure each month. But we can not
get the negative time to work on the sheet.
We tried the 1904 format but it still did not work.
We are using Excel 2k for windows.
The formula we are using is [hh]:mm
any other help would be appreciated.
Thanks
Steve