Excel 2007 : Convert decimal to time

**jbritt** · 01-02-2010, 11:19 AM

can some one please show me how to convert decimal to time. attached is a draft of my projectLeave_Tracker(1).xls

**shg** · 01-02-2010, 11:33 AM

Welcome to the forum.

If the decimal value is hours, divide by 24 to get an Excel time (and format as time).

**jbritt** · 01-02-2010, 05:09 PM

thanks for the reply, but this will need to be step step process for me. I am not Excel literate

**shg** · 01-02-2010, 05:12 PM

I don't know where you want to apply it.

**jbritt** · 01-02-2010, 11:18 PM

that is why I had the attachment in the original reguest

**teylyn** · 01-02-2010, 11:46 PM

that is why I had the attachment in the original reguest

Uhmm, well, that's why it would be helpful to point out which of your decimals you'd want to convert to time. Don't assume that your spreadsheet is immediately understandable for anyone, just because you wrote it.

Specify which cells you'd want to convert to time and specify where you want the result to be displayed. Use cell addresses like A1 or K17 ....

**shg** · 01-03-2010, 04:05 PM

If you're amenable to doing this in somewhat less colorful fashion, perhaps as attached. Data is arranged in one record per row, and times are in hours. The 'used leave' columns are formatted to suppress display of zero values.

The sheet is protected to prevent inadvertent changing of formulas (the light gray cells). No password.