![]() |
|
#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. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
MOD function with a time field
|
H28Sailor | Excel | 1 | 07-20-2013 12:57 AM |
MATCH function and time values
|
hanvyj | Excel | 2 | 05-29-2013 12:12 PM |
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 |
Macro or Function to know wether a string is included in a text
|
Eduardo | Word VBA | 5 | 06-15-2009 01:55 AM |