Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Convert [h]:mm:ss to Decimal Hours to Count FTE for Month
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 09-18-2015, 02:11 AM
Ethan2015 Ethan2015 is offline Convert [h]:mm:ss to Decimal Hours to Count FTE for Month Windows 7 32bit Convert [h]:mm:ss to Decimal Hours to Count FTE for Month Office 2007
Novice
Convert [h]:mm:ss to Decimal Hours to Count FTE for Month 		 
Join Date: Sep 2015
Posts: 2
Ethan2015 is on a distinguished road
Unhappy 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
Reply With Quote
  #2  
Old 09-18-2015, 03:51 AM
macropod's Avatar
macropod macropod is offline Convert [h]:mm:ss to Decimal Hours to Count FTE for Month Windows 7 64bit Convert [h]:mm:ss to Decimal Hours to Count FTE for Month Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,363
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Just multiply by 24 and apply the 'General' format to the result...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-18-2015, 03:55 AM
Ethan2015 Ethan2015 is offline Convert [h]:mm:ss to Decimal Hours to Count FTE for Month Windows 7 32bit Convert [h]:mm:ss to Decimal Hours to Count FTE for Month Office 2007
Novice
Convert [h]:mm:ss to Decimal Hours to Count FTE for Month 		 
Join Date: Sep 2015
Posts: 2
Ethan2015 is on a distinguished road
Default
Thank you, I had figured it out.... foregot to close this forum but thank you anyway!
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear 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
Convert [h]:mm:ss to Decimal Hours to Count FTE for Month Converting decimal to hours jhwtsang Excel 4 05-16-2011 01:36 PM
Convert [h]:mm:ss to Decimal Hours to Count FTE for Month Excel convert format [h]:mm:ss to decimal gchan2000 Excel 1 08-17-2010 01:36 PM
Convert [h]:mm:ss to Decimal Hours to Count FTE for Month 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 02:08 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft