Support Board
Date/Time: Thu, 18 Dec 2025 19:28:58 +0000
Post From: Spread Sheet pop-up question
| [2014-01-25 00:07:02] |
| Sawtooth - Posts: 4300 |
|
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 |