So I have a simple Project Timesheet that I wish to use. I have found that if I use the format cells custom feature and enter 0\:00 I can input just the numbers and it will express them with the colon without having to type it. I also found an example where using a hidden column you should be able to convert this to time so that in the number of hours worked column it will show correctly as hours and not decimals. (ie 7:45 hours and not 7:75). The formula that the person had input and in their spreadsheet it worked was =TIME(TRUNC(B4/100),MOD(B4,100),0) I have managed to get this to work if I put the cell format to h:mm.
I am still having problems getting a formula that will give me the number of hours worked. The sample timesheet had columns for a lunch hour that I do not require which was =IF(E4-C4>0,E4-C4-J4,""), and a simple E4-C4 does not work. I have one final column that requires a running total to a final total at the end. I have gone through the forum and the other Timesheets that I have seen have seemed very complicated for what I want to do.
I am sure there is a simple explanation as to why this will nor work but I can't see it. I am not sure how to put the spreadsheet up here as an example so if someone could let me know that also I would appreciate it, as I realize that it is easier to solve something if you can actually see it. Below is a list of the columns that I am currently working with.
Columns
A - Date
B - Start Time
C - hidden column with formula to change to time
D - End Time
E - hidden column with formula to change to time
F - Task Description
G - Daily Hours
H - Total Hours
Thanks
Hils
Bookmarks