Convert [h]:mm:ss to Decimal Hours to Count FTE for Month

		Microsoft Office Forums > Microsoft Excel > Excel
Convert [h]:mm:ss to Decimal Hours to Count FTE for Month

FAQ

Mark Forums Read

Thread Tools

Display Modes

09-18-2015, 02:11 AM

Ethan2015

Windows 7 32bit Convert [h]:mm:ss to Decimal Hours to Count FTE for Month

Office 2007

Novice

Join Date: Sep 2015

Posts: 2

Convert [h]:mm:ss to Decimal Hours to Count FTE for Month

Hi There,

I am trying to work out how to convert [h]:mm:ss to a decimal so I can figure out my total FTE for the month.

E.g.

Cell B17 has 371:29:35, I need to know what that would be as a decimal.

Usually as hh:mm:ss I would *(24*60*60) however, that does not seem to work correctly as [h]:mm:ss. (Please note this is for one month)

Please help

Last edited by Ethan2015; 09-18-2015 at 02:21 AM. Reason: Change Wording

« 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
Formula for decimal hours from two date time entries	DBenz	Excel Programming	0	01-15-2015 05:52 AM
Formula to count entries as per month, year and submission wise from different sheets	pinkacidpunk	Excel	1	05-28-2013 08:26 AM
Converting decimal to hours	jhwtsang	Excel	4	05-16-2011 01:36 PM
Excel convert format [h]:mm:ss to decimal	gchan2000	Excel	1	08-17-2010 01:36 PM
Convert hours in decimal	ghostones	Excel	1	12-29-2009 09:17 PM

Other Forums: Access Forums

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