Convert hours in decimal

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:15 PM.