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

Today, in Episode #1387, Bill H. asks, "How do I change a date/time field from midnight to 6PM?" Since Microsoft Excel stores time values as a Fractional portion of a day [where a day is = to 1], MrExcel shows us how to change our time values using Paste Special - a quick and efficient solution!

…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.