Thread: [Solved] Time from text function
View Single Post
 
Old 07-09-2014, 02:53 AM
wannaExcel wannaExcel is offline Windows 7 64bit Office 2013
Novice
 
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