Hi All,
I've been given a spreadsheet for work that they want us to use to calclate time spent in each area. I don't understand the formula at all but the problem is the total time column is incorrect, as you can see in my attached sheet the start time is 8:00 finish is 10:18 column D should read 2.3 hrs not 2 hrs. As I said I don't understand the formula so I have no idea how to fix it & the person who made the sheet is on leave. Any help will be very much appreciated.
Cheers Moppy.
Last edited by moppyau; 05-07-2013 at 09:59 PM. Reason: Typo
1.3 or 2.3?
=IF(FinishTime_4="","",(C6-B6)*24)
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Yeah sorry 2.3. That works perfectly. Thank-you vlady.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks