Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 07-09-2014, 02:53 AM
wannaExcel wannaExcel is offline Time from text function Windows 7 64bit Time from text function Office 2013
Novice
Time from text function
 
Join Date: Jul 2014
Posts: 9
wannaExcel is on a distinguished road
Default Text Function Help

I have upload a file in which the time difference between start time and finish time is a formula using Text function to convert to time but in cells G5:G8 & I5:I8 I would like those to update automatically , they will but then any additional formulas I have that use those cell as a reference don't work... format is a number in a cells??? if you change the cell G5 to =F5 the number in M8 will change and because I typed the numbers in manually the formula works..

Thank you to all the response//
I appreciate your time on this matter
Attached Files
File Type: xlsm June 2014.xlsm (26.2 KB, 12 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Time from text function MOD function with a time field H28Sailor Excel 1 07-20-2013 12:57 AM
Time from text function MATCH function and time values hanvyj Excel 2 05-29-2013 12:12 PM
Time from text function Wrap Text function not working? mhays Excel 1 11-21-2012 05:03 PM
Insert Text Function-Default Cursor @ pg top sncw Word 1 11-20-2010 03:15 PM
Time from text function Macro or Function to know wether a string is included in a text Eduardo Word VBA 5 06-15-2009 01:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:51 PM.


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