Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #13  
Old 11-05-2018, 02:53 PM
Marcia's Avatar
Marcia Marcia is offline adding up hours as numbers doesnt match hours as time format Windows 7 32bit adding up hours as numbers doesnt match hours as time format Office 2007
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

The net credit hours display ############# because the net result from task 1 to 5 is negative, meaning the workers clocked in more hours on the tasks than the total allowed hours of work.


To get the 11 hour days, you multiply your initial formula by 24, the total hours in a day.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Hours in MS Project with Picture Hochbau Project 6 02-17-2017 09:45 AM
Calculate Time in Hours and Percent pabyford Excel 6 12-13-2016 12:29 PM
Time Function for Tracking Hours Newto365 OneNote 0 07-11-2016 09:47 AM
adding up hours as numbers doesnt match hours as time format 8 in 24 hours time formula v1rt8v2 Excel 7 01-12-2016 06:55 PM
adding up hours as numbers doesnt match hours as time format Adding of times total to be in hours jen0dorf Excel 4 06-20-2014 11:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:36 AM.


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