Help Im trying to calculate the number of hours worked on different projects but im having real trouble,
I have calculated manually that a caseworker has completed one piece of work for 95 minutes and should appear as 1.35 but currently appears as 192.00 even with the cell formatted with [H]:mm
can someone please help me??????????
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Daniel,
Do you have input cells for "start" and "end" times and are these cells formatted as h:mm? You should be entering time values in the manner Excel expects them using the colon, e.g.: 09:15, 13:45, etc.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks