![]() |
#1
|
|||
|
|||
![]()
=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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
H28Sailor | Excel | 1 | 07-20-2013 12:57 AM |
![]() |
hanvyj | Excel | 2 | 05-29-2013 12:12 PM |
![]() |
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 |
![]() |
Eduardo | Word VBA | 5 | 06-15-2009 01:55 AM |