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.
|