Learn Excel - It's 6 O'clock Somewhere: #1387
Sign Up![](https://srv.veoh.com/images/veohplayerLoading.gif?version=N500)
This is a 5 minute preview of a 2 minute video
Install Web Player Beta to watch the full video in your browser or download it to your PCYou're watching a full 2 minute video using the Veoh Web Player
To download the original quality video, select the Download Options link below- By:
- mrexcel
- Description
- Today, in Episode #1387, Bill H. asks, "How do I change a date/time field from midnight to 6PM?" Excel stores time values as a Fractional portion of a day [where a day is = to 1], so MrExcel shows us how to change our time values using Paste Special.
- Language:
- English
Would you like to comment?
Sign Up Now for a free account or Log In.