Excel Negative Time Format

mole999

Well-known Member

Joined

Oct 23, 2004

Messages

10,524

Office Version

1. 2019
2. 2016
3. 2013

Platform

1. Windows

• Dec 26, 2008

• #2

as a guess the : is a time separator so maybe it interpreted as 00:00

though testing on a blank workbook

: = :

-0.0416666666666667 = as time = 00/01/1900 01:00:00

once i have made a cell time the rest of the book then converts 1/24 into 01/01/2024

 

Upvote 0

mole999

Well-known Member

Joined

Oct 23, 2004

Messages

10,524

Office Version

1. 2019
2. 2016
3. 2013

Platform

1. Windows

• Dec 26, 2008

• #3

OK, what was the fourth key

i saw spacebar, colon, enter

as for the hashes its negative time

 

Upvote 0

E

Emily

Active Member

Joined

Aug 28, 2002

Messages

304

• Dec 26, 2008

• #4

: <--- two keys Shift + :

 

Upvote 0

J

Jeffrey Green

Well-known Member

Joined

Oct 24, 2007

Messages

1,021

• Dec 26, 2008

• #5

When I see that, I usually find that one of the "times" involved is not properly formatted.

 

Upvote 0

E

Emily

Active Member

Joined

Aug 28, 2002

Messages

304

• Dec 27, 2008

• #6

mole999 said:

as a guess the : is a time separator so maybe it interpreted as 00:00

though testing on a blank workbook

: = :

-0.0416666666666667 = as time = 00/01/1900 01:00:00

once i have made a cell time the rest of the book then converts 1/24 into 01/01/2024

Click to expand...

Elaborate more:

when input
Spacebar + : + 1 shows 00:59
Spacebar + : + 2 shows 01:59
...
Spacebar + : + 24 shows 23:59
Spacebar + : + 25 shows 01/01/1900 12:59:00 AM
...
Spacebar + : + 9999 shows 19/02/1901 02:59:00 PM

9999 is the maximum value that can display time format, and also

Spacebar + : + 0 shows -0.000694444444444444

 

Upvote 0