Posts Tagged ‘Time’

Choosing Quarters in Excel

June 22nd, 2009

There’s an old quip that says dyslexic philosophers lay awake at night wondering if there is a dog.

Well I’m not dyslexic but a few things tug at my mind at night. For example:  Why don’t more women find me attractive?  What’s this stuff on my feet?  And why isn’t there a function in Excel that translates a date into a quarter?

That’s right, there is no native function in Excel that converts a date into a quarter. Amazing, is it not?

Here is an easy technique for converting a date into a quarter using the CHOOSE function.

» More: Choosing Quarters in Excel

Convert Numbers to Military Times in Excel

June 17th, 2009

In his last desperate act before taking a handful of Ambien, M. DeRevere asks:

How can I program a cell to accept time formulas without putting the (:) colons between the numbers… if you could format the cell to accept just number such as 2300 and it formats it as 23:00 it would save me sooooo much time?… HELP

Well hold off on the pills M.  Because I’m rockin the Excel skillz , and I happen to know the answer.

M’s question revolves around “military” time (the 24 hour clock).  For you civilians out there, 23:00 hours is 11:00 pm in military time.  The trick is to apply some custom number formatting.

  » More: Convert Numbers to Military Times in Excel