I have a spreadsheet which I have made into a timesheet (see attached) and I would like it to calculate the Total hours/minutes that are in the "mins on task" column D.
I do not want it to be in time format as I want them to just enter the time they spent on that task. The users are not very good with computers.
They will only be able to amend the yellow sections of this spreadsheet.
e.g.
Mins on task
15
30
60
120
TOTAL: 3.75
Hi ELTAMA,
In D23 try "=SUM(D15:D22)/60"
i wonder if you don't really want 3.45 instead of 3.75?
One test is worth a thousand opinions.
Click the * below to say thanks.
Try
=SUM(D15:D22)/60
To thank someone who has helped you, click on the star icon below their name.
I hate reading
Portfolio
I need a job.I am young and incompetent
try this and let us know if this works for you.
There is no substitute for clean data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks