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;
- May 16 Wed 2007 20:37
entering negative time values in excel
close
全站熱搜
留言列表
發表留言