How to add whole & decimel quantities in separate columns?

**Superflybriguy** · 11-15-2011, 02:09 PM

Hi all,

Long time lurker, first time poster.

I have two columns A and B

Column A is whole hours
Column B is decimel hours

http://img265.imageshack.us/img265/7910/excelm.jpg

How do I get the total of 20.6 hours to show as 20 whole hours in column A and 6 decimel hours in column B

Thanks a bunch, everybody!

Brian

**Special-K** · 11-15-2011, 02:27 PM

Assuming time is in C1

in A1
=INT(C1)

in B1
=C1-A1

**tigeravatar** · 11-15-2011, 02:33 PM

Brian,

Attached is an example workbook based on your sample criteria.

In cell A5 is the formula:
=SUM(A1:A4)+INT(SUM(B1:B4)/10)

In cell B5 is the formula:
=MOD(SUM(B1:B4),10)