close

I need to enter a negative time value in excel but can't work out how to do
it. Can anyone help?

Thanks

First, you'll want to change to the 1904 date system.
Tools|options|Calculation tab

Then you can enter the negative time like:

=-TIME(1,30,0)
for -1:30 AM

You could also use:
=-quot;01:30:00quot;
(but format the cell as time)

Be aware that if you have dates in your workbook, they'll change by 4 years and
a day.

dona wrote:
gt;
gt; I need to enter a negative time value in excel but can't work out how to do
gt; it. Can anyone help?
gt;
gt; Thanks

--

Dave Peterson

Thanks for that, unfortunately I don't think that will help in my particular
circumstances.

This is for a time sheet that will be used by lots of people, most of whom
will be Excel novices. They will need to be able to enter, for example
-01:00, if they have worked 1 hour less than their conditioned hours.

I think I need some way of formatting the cell that that either positive or
negative time values can be entered.

Unfortunatley it is also not a cell that could be populated with a formula.

Any suggestions?

quot;Dave Petersonquot; wrote:

gt; First, you'll want to change to the 1904 date system.
gt; Tools|options|Calculation tab
gt;
gt; Then you can enter the negative time like:
gt;
gt; =-TIME(1,30,0)
gt; for -1:30 AM
gt;
gt; You could also use:
gt; =-quot;01:30:00quot;
gt; (but format the cell as time)
gt;
gt; Be aware that if you have dates in your workbook, they'll change by 4 years and
gt; a day.
gt;
gt;
gt;
gt;
gt; dona wrote:
gt; gt;
gt; gt; I need to enter a negative time value in excel but can't work out how to do
gt; gt; it. Can anyone help?
gt; gt;
gt; gt; Thanks
gt;
gt; --
gt;
gt; Dave Peterson
gt;

I don't have any other suggestions.

dona wrote:
gt;
gt; Thanks for that, unfortunately I don't think that will help in my particular
gt; circumstances.
gt;
gt; This is for a time sheet that will be used by lots of people, most of whom
gt; will be Excel novices. They will need to be able to enter, for example
gt; -01:00, if they have worked 1 hour less than their conditioned hours.
gt;
gt; I think I need some way of formatting the cell that that either positive or
gt; negative time values can be entered.
gt;
gt; Unfortunatley it is also not a cell that could be populated with a formula.
gt;
gt; Any suggestions?
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; First, you'll want to change to the 1904 date system.
gt; gt; Tools|options|Calculation tab
gt; gt;
gt; gt; Then you can enter the negative time like:
gt; gt;
gt; gt; =-TIME(1,30,0)
gt; gt; for -1:30 AM
gt; gt;
gt; gt; You could also use:
gt; gt; =-quot;01:30:00quot;
gt; gt; (but format the cell as time)
gt; gt;
gt; gt; Be aware that if you have dates in your workbook, they'll change by 4 years and
gt; gt; a day.
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; dona wrote:
gt; gt; gt;
gt; gt; gt; I need to enter a negative time value in excel but can't work out how to do
gt; gt; gt; it. Can anyone help?
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Use multiple cells?

One for the time and one for /- indicator and then one that combines the two?

dona wrote:
gt;
gt; Thanks for that, unfortunately I don't think that will help in my particular
gt; circumstances.
gt;
gt; This is for a time sheet that will be used by lots of people, most of whom
gt; will be Excel novices. They will need to be able to enter, for example
gt; -01:00, if they have worked 1 hour less than their conditioned hours.
gt;
gt; I think I need some way of formatting the cell that that either positive or
gt; negative time values can be entered.
gt;
gt; Unfortunatley it is also not a cell that could be populated with a formula.
gt;
gt; Any suggestions?
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; First, you'll want to change to the 1904 date system.
gt; gt; Tools|options|Calculation tab
gt; gt;
gt; gt; Then you can enter the negative time like:
gt; gt;
gt; gt; =-TIME(1,30,0)
gt; gt; for -1:30 AM
gt; gt;
gt; gt; You could also use:
gt; gt; =-quot;01:30:00quot;
gt; gt; (but format the cell as time)
gt; gt;
gt; gt; Be aware that if you have dates in your workbook, they'll change by 4 years and
gt; gt; a day.
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; dona wrote:
gt; gt; gt;
gt; gt; gt; I need to enter a negative time value in excel but can't work out how to do
gt; gt; gt; it. Can anyone help?
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Thanks, I will try that.

quot;Dave Petersonquot; wrote:

gt; Use multiple cells?
gt;
gt; One for the time and one for /- indicator and then one that combines the two?
gt;
gt; dona wrote:
gt; gt;
gt; gt; Thanks for that, unfortunately I don't think that will help in my particular
gt; gt; circumstances.
gt; gt;
gt; gt; This is for a time sheet that will be used by lots of people, most of whom
gt; gt; will be Excel novices. They will need to be able to enter, for example
gt; gt; -01:00, if they have worked 1 hour less than their conditioned hours.
gt; gt;
gt; gt; I think I need some way of formatting the cell that that either positive or
gt; gt; negative time values can be entered.
gt; gt;
gt; gt; Unfortunatley it is also not a cell that could be populated with a formula.
gt; gt;
gt; gt; Any suggestions?
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; First, you'll want to change to the 1904 date system.
gt; gt; gt; Tools|options|Calculation tab
gt; gt; gt;
gt; gt; gt; Then you can enter the negative time like:
gt; gt; gt;
gt; gt; gt; =-TIME(1,30,0)
gt; gt; gt; for -1:30 AM
gt; gt; gt;
gt; gt; gt; You could also use:
gt; gt; gt; =-quot;01:30:00quot;
gt; gt; gt; (but format the cell as time)
gt; gt; gt;
gt; gt; gt; Be aware that if you have dates in your workbook, they'll change by 4 years and
gt; gt; gt; a day.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; dona wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; I need to enter a negative time value in excel but can't work out how to do
gt; gt; gt; gt; it. Can anyone help?
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()