Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-03-2018, 11:08 AM
DBenz DBenz is offline adding up hours as numbers doesnt match hours as time format Windows 7 64bit adding up hours as numbers doesnt match hours as time format Office 2010 32bit
Advanced Beginner
adding up hours as numbers doesnt match hours as time format
 
Join Date: Dec 2014
Posts: 69
DBenz is on a distinguished road
Default

Hi, file attached.
stumped on why total is just 15 mins
using sum(g4:g41) method or just a+b+c etc.


I wanted to have the credit debit figure add them up and subtract from the total to see time remaining.


Can someone sort this out please as the time its taking me to create it to see how close to failure I will be given the time I have left to do it, means ironically I wont manage to get the job done due to time spent instead trying to get the excel spread sheet made , as I am counting hrs now, stop and I fail !!


I just need a fixed chart now, no time left for fiddling.



DBenz
Attached Files
File Type: xlsx Task time estimator and progress credit debit.xlsx (15.6 KB, 13 views)
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 07:03 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