Hi! I wonder if it's possible to add 24 hours to a time value so Excel understands that it's the day after. If I just add 1 to 02:00 for example, the result is just 02:00 but it doesn't understand that it's actually one day after it (I'm doing this to compare two time values and when you compare for example 02:00 with 23:00 Excel think 23:00 is the higher value). Do you have to have dates involved for this?
Bookmarks