Results 1 to 3 of 3

Thread: Time conversion help

  1. #1
    New Member
    Join Date
    Sep 2019
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Time conversion help

    Hi,

    Hoping Toadstool will see this as he knows the history of what I have been trying to do. But if anyone can help I would be so grateful.

    I am doing timesheets and have formulas in now that work for adding hours over multiple rows and then multiplying it by 1.5 and 2.

    What I need now is I have it set up as below;

    Start Time Break Finish time
    08:00 1:00 17:00
    09:00 00:30 17:00

    With the break column if I type in 00:30 it works if I type :30 then it doesn't recognize it and the formulas surrounding it don't work or if I was to type in .5 it won't recognise that either.

    I need to get the break time to convert when it is typed in into time format but even if I format the cells it isn't working. This should be so simple but it just isn't working for me. I am using Google Excel Sheets

    Help would be appreciated

  2. #2
    Board Regular Toadstool's Avatar
    Join Date
    Mar 2018
    Posts
    250
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Time conversion help

    Hi Nunya1,

    As I responded to your PM...

    I'm sorry but I don't use Google Sheets (as I find it very slow) but I see two options:

    1. Use decimal hours for the break (e.g. 15 minutes entered as .25) but then you'll need to change all your other calculations to convert that back to parts of an hour.

    2. Select the smallest unit which can be offered for a break and do a Data Validation list offering those increments.
    e.g. 00:15,00:30,00:45,01:00,01:15,01:30,01:45,02:00 and etc. if they may have long breaks.
    Life advice found on a book of matches: "Keep cool. Keep away from children."

  3. #3
    New Member
    Join Date
    Sep 2019
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Time conversion help

    Yeah I did see your response before thank you. I have just gone with the data validation that will be the easiest for everyone I think.

    And finally I can say these fkn timesheets are done thank you it would have taken me at least 2 weeks to work this out by myself.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •