Support Board
Date/Time: Fri, 09 May 2025 23:19:10 +0000
Post From: Spread Sheet pop-up question
| [2014-01-25 00:07:02] |
| Sawtooth - Posts: 4214 |
|
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 |