Learn Excel - It's 6 O'clock Somewhere: #1387

Name: Learn Excel - It's 6 O'clock Somewhere: #1387
Uploaded: 2011-04-20T13:47:45+00:00
Duration: 166 s
Channel: Bill Jelen
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 ...

40 views · 14y ago 🎲 Random

Bill Jelen View Channel →

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.