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