Converting number to hours

		Microsoft Office Forums > Microsoft Excel > Excel
Converting number to hours

FAQ

Mark Forums Read

Thread Tools

Display Modes

04-08-2017, 11:24 PM

Pecoflyer

Windows 7 64bit Converting number to hours

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Hello
to do this, divide by 24 and format as time

Also read http://www.cpearson.com/excel/datetime.htm to understand how XL works with time and dates

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« 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
Holiday report excel - pull +/- hours from cells containing text and number	bobby123456789	Excel	2	12-09-2016 09:05 AM
How to create a table with a number of line depending a number entered by user	Cellendhyll	Word Tables	3	07-10-2014 05:49 AM
Converting serial number to years, months and days	hannu	Excel	6	02-14-2013 09:21 PM
Converting hh:mm to hours	Sammael	Excel	2	04-17-2012 01:33 PM
Converting decimal to hours	jhwtsang	Excel	4	05-16-2011 01:36 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:33 AM.