Convert hours in decimal

		Microsoft Office Forums > Microsoft Excel > Excel
Convert hours in decimal

FAQ

Thread Tools

Display Modes

12-29-2009, 09:17 PM

s_pandeymanoj s_pandeymanoj is offline

Windows 98/ME Convert hours in decimal

Office 97

Novice

Join Date: Dec 2009

Posts: 5

s_pandeymanoj is on a distinguished road

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:03 AM.