Support Board
Date/Time: Mon, 25 Nov 2024 09:43:50 +0000
Post From: Spread Sheet pop-up question
| [2014-01-25 00:07:02] |
| Sawtooth - Posts: 4120 |
|
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 |