Login Page - Create Account

Support Board


Date/Time: Tue, 23 Apr 2024 18:41:42 +0000



Post From: Spread Sheet pop-up question

[2014-01-25 00:07:02]
Sawtooth - Posts: 3976
Try changing the cell format to Time, then use only 08:05:00 and 22:00:00 in cells J1 and J2 (don't use the TIMEVALUE function):

-highlight cells J1 and J2
-right click in the highlighted cells >> Number Format >> Time >> h:mm:ss