Convert hours in decimal

ghostones · #1 12-10-2009, 10:16 AM

I wanted to convert hours in decimal for E.g. if i have a figure of 31:35 it needs to be converted into 31.35.

Please help it will really reduce my workload.

s_pandeymanoj · #2 12-29-2009, 09:17 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Actual working hours per day	climbatron	Project	2	12-17-2015 03:13 PM
Convert JML files	Lundberg	Word	5	09-11-2010 11:05 AM
Merge, Too many Numbers right of the Decimal Point	ohdearme	Mail Merge	0	10-25-2009 05:10 PM
Need urgent help .. lost 6 hours of work .. assignments due in tomorrow	Phatmat	Word	1	10-15-2009 08:38 AM
convert	golden039	Word	0	08-16-2009 05:48 PM