M
marbles
Guest
hi all
i'm trying to use the HH:MM, but everytime i type in a number, two problems happen;
1a. if i type in 3, it doesn't show 3, it shows 00:00
but i click on the cell, it will show 72:00:00
if i type in 4, it doesn't show 4, it shows 00:00
but i click on the cell, it will show 96:00:00
1b. it doesn't show 72:00:00, i only see it in top bar
2. rather than figuring out this weird behavior, perhaps you smart people can find an easier of doing this - i'm trying to find the hours between two HOURs...for example
6hours-3hours =3hours
thx
i'm trying to use the HH:MM, but everytime i type in a number, two problems happen;
1a. if i type in 3, it doesn't show 3, it shows 00:00
but i click on the cell, it will show 72:00:00
if i type in 4, it doesn't show 4, it shows 00:00
but i click on the cell, it will show 96:00:00
1b. it doesn't show 72:00:00, i only see it in top bar
2. rather than figuring out this weird behavior, perhaps you smart people can find an easier of doing this - i'm trying to find the hours between two HOURs...for example
6hours-3hours =3hours
thx