Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
EXCEL CALCULATE NEGATIVE HOURS
- Thread starter amecari
- Start date
SkipVought
Programmer
amecari,
That's because you are entering a TIME value and NOT ELAPSED TIME or RELATIVE TIME.
Time values are NUMBERS, FRATIONAL values like .5 can be FORMATTED as 12:00 PM (.5 of a day) and TIME values are usually associated with DATE values which are NUMBERS greater than 1, like today is 38125 which can be FORMATTED 5/18/2004.
so, if you want to ADD positive or negative hours (in B1 as just a number) and your base time value is in A1...
[tt]
=A1+B1/24
[/tt]
the formula is
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
That's because you are entering a TIME value and NOT ELAPSED TIME or RELATIVE TIME.
Time values are NUMBERS, FRATIONAL values like .5 can be FORMATTED as 12:00 PM (.5 of a day) and TIME values are usually associated with DATE values which are NUMBERS greater than 1, like today is 38125 which can be FORMATTED 5/18/2004.
so, if you want to ADD positive or negative hours (in B1 as just a number) and your base time value is in A1...
[tt]
=A1+B1/24
[/tt]
the formula is
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
- Status