Microsoft Office Forums - View Single Post - [Solved] Convert hours in decimal

Thread: [Solved] Convert hours in decimal

View Single Post

Old

12-29-2009, 09:17 PM

s_pandeymanoj s_pandeymanoj is offline

s_pandeymanoj is offline

s_pandeymanoj uses Windows 98/ME

Windows 98/ME s_pandeymanoj uses Office 97

s_pandeymanoj uses Office 97

Office 97

Novice

Join Date: Dec 2009

Posts: 5

s_pandeymanoj is on a distinguished road

Default

Hi,

You can use the following formulas:

1. =(Cellname-INT(cellname))*24

2. =((cellname)*1440)/60
1440 is number of minutes in one day (60*24)/60 (one minute)

Hope this work for you.

Regards,

Manoj

Reply With Quote