USD $30.00 Seeking totals by month, and working hours

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    Hello, $3.00 has been paid to [email protected]


    For this project I need the totals, by month, from the data that is entered on the Sea Log Test tab, to populate to the table on the DATA Tab. Then also on the Graph Test Tab.


    I also need the working hours to populate on the Sea Log tab as shown in the highlighted cells Example, when a user enters the information in columns P & Q. Our observed holidays are listed.


    The Data in columns A thru Q is entered manually on the Sea Log Test Tab by users. I’m sorry if I am being too Vague, Please let me know if you have any questions.

    Re: USD $30.00 Seeking totals by month, and working hours


    I can look at this for you.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Re: USD $30.00 Seeking totals by month, and working hours


    Hello KjBox, I had one other question on this, can the graph page be made to look like a power point? Or a full page picture?

    Re: USD $30.00 Seeking totals by month, and working hours


    In rows 9 to 20 on the Sea Log sheet the Stop Dates that are earlier than Received Dates for each of those quotes. Is that an error in the data or something that can actually happen?

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Re: USD $30.00 Seeking totals by month, and working hours


    Quote from KjBox;787149

    In rows 9 to 20 on the Sea Log sheet the Stop Dates that are earlier than Received Dates for each of those quotes. Is that an error in the data or something that can actually happen?

    This is an error in the example data. Thanks, this would never happen.

    Re: USD $30.00 Seeking totals by month, and working hours


    OK, thanks. I will switch the values in the affected rows so the dates make more sense and the formulas will work! :)

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Re: USD $30.00 Seeking totals by month, and working hours


    Quote from KjBox;787207

    OK, thanks. I will switch the values in the affected rows so the dates make more sense and the formulas will work! :)


    Hello KjBox, Please update on this project. Hoping to get it before I go home for the weekend. Thank you -

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login