Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-06-2014, 05:42 PM
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 Time from text function

=TEXT(B2-A2,"hh.mm")


Cells A2 is start time
Cell B2 is end time of course results are in cell C2

What I would like to do is see that same number in another cell but as a number

so Cell F2 "=C2"

if there is a post on this some where else that I haven't found I apologize, if you can point me in the right direction...

Thank you for your time..

This is to keep track of work hours, I need to add the hours up for each week but if I use sum it shows 0.00

Last edited by wannaExcel; 07-06-2014 at 07:32 PM.
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 11:21 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