convert number to time

[Jay Ess 6]

i have a number 18.9413 and need to convert it to a time string the result i should get is 18:56:29

 

how can i do that please?

[SmartHomeEddy 1,005]

It is not epoch, what is the logic behind your number?

[jgab 2,642]

Maybe not that most efficient

Please login or register to see this code.

 

Edited December 22, 2021 by jgab

[Jay Ess 6]

5 hours ago, jgab said:

Maybe not that most efficient

Please login or register to see this code.

 

amazing @jgab as always so spot on and thank you for your help.

[Jay Ess 6]

5 hours ago, SmartHomeEddy said:

It is not epoch, what is the logic behind your number?

it is working sun times, in particular trying to get the time when the sun is 8 degrees below the horizan

[SmartHomeEddy 1,005]

Ah, Decimal time

 

Please login or register to see this link.

 

Decimal time is the representation of the time of day using units which are 

Please login or register to see this link.

 related. This term is often used specifically to refer to the time system used in 

Please login or register to see this link.

 for a few years beginning in 1792 during the 

Please login or register to see this link.

, which divided the day into 10 decimal hours, each decimal hour into 100 decimal minutes and each decimal minute into 100 decimal seconds (100000 decimal seconds per day), as opposed to the more familiar 

Please login or register to see this link.

 

Please login or register to see this link.

, which divides the day into 24 

Please login or register to see this link.

, each hour into 60 

Please login or register to see this link.

 and each minute into 60 

Please login or register to see this link.

 (86400 

Please login or register to see this link.

 seconds per day)…

[Sjakie 156]

@Jay Ess,

are you willing to post your complete calculation sunrise and sunset? Looks interesting to use.

Thanks in advance,

//Sjakie

[Jay Ess 6]

@Sjakie at the moment it is not working properly, have managed to set it up using sample code based on a particluar time and zone but when i try to run it on current dates and time and different time zone it bring back results which dont make sense.

 

once i have managed to get it working i will be happy to post it.

 

I do have a sunset/sunrise calculator but it is out by between 1 and 3 minutes depedning on the time of the year, hence why i am trying to fine tune it.

[SmartHomeEddy 1,005]

Maybe someone can help you @Jay Ess with your code

[Sjakie 156]

At this moment I use to minimize the deviation a correction by month followed by % clouds.

This is close to wath I want but % clouds has sometimes a big deviation.

What I have works more convenient as an outside PIR.

//Sjakie

[Jay Ess 6]

@SmartHomeEddy @Sjakie

 

Edited December 27, 2021 by Jay Ess

[SmartHomeEddy 1,005]

Just checking, did you looked at this quickapp?

 

Please login or register to see this link.

 

 

[Jay Ess 6]

@SmartHomeEddythank you for that link, will have a look at it.

 

had to take down my code as posted by error.

 

 

would you know how to get a specific time for a sun a position from that code please?

Edited December 27, 2021 by Jay Ess

[Jay Ess 6]

On 12/22/2021 at 11:01 AM, jgab said:

Maybe not that most efficient

Please login or register to see this code.

 

think i am almost there, i need to take the result of this time, ie. 18:56:29 and then round it up or down to the nearest minute depeding on what i am working out, what is the most effecient way to do that please?

 

 

 

Edited December 30, 2021 by Jay Ess

[jgab 2,642]

function decTime2StringMinutes(a)
  return string.format("%02d:%02d",math.floor(a),math.floor(0.5+math.fmod(a,1)*60))
end

[Jay Ess 6]

@jgabthank you and use math.ceil for rounding up correct?

 

so i now have a funtion to get the time, but at the moment the angle value is just a single number as in 0.83333, i want to run this function with a table of numbers, as take your function

function decTime2StringMinutes(a)
  return string.format("%02d:%02d",math.floor(a),math.floor(0.5+math.fmod(a,1)*60))
end

 

for a i want to pass it a table of numbers.

 

function QuickApp:GetTimes()

    local sunPosition = {

        ["SunSet"] = 1,

        ["blueHourDuskEnd"] = 2

    }

    local sortedKeys = 

        getSortedKeysByValue(

        sunPosition,

        function(a,b)

            return a < b

        end

    )

    --local sunTimes = nil

    for _,key in ipairs(sortedKeys) do

        print(key)

    end

end

but this does not work if i call it as GetTimes()

[Jay Ess 6]

I have managed to build a table and iterate through it but the code seems clunky, how can i tidy this up please?

 

function QuickApp:GetTimes()

    local sunPosition = {

        ["SunSet"] = -0.8333,

        ["blueHourDuskEnd"] = -8

    }

    function pairsByKeys (t, f)

      local a = {}

      for n in pairs(t) do table.insert(a, n) end

      table.sort(a, f)

      local i = 0      -- iterator variable

      local iter = function ()   -- iterator function

        i = i + 1

        if a[i] == nil then return nil

        else return a[i], t[a[i]]

        end

      end

      return iter

    end

    for name , angle in pairsByKeys(sunPosition)do

        R = angle

        print(hms(T))

    end

end

[jgab 2,642]

If you want to print out a key/value table in some specific order I recommend you to move the key/value to an array and sort the array on the keys.

The create an iterator like in your case is massive overkill and not more efficient.

Please login or register to see this code.

 

Edited December 30, 2021 by jgab

[Jay Ess 6]

@jgab that is amazing thank you, if i want to have three "fields" per row of data, need to change a calculation based on what angle i need, how would i do that?

 

this is what my end table should be like

        {name = "sunset",angle = -0.8333, time = "A"}

        {name = "shabbosout",angle = -8, time = "A"}

 

 

[Jay Ess 6]

thank you for all your help, i am one LOL step away from a working qa, i am stuck on round a decimal number as in 16.989568650404 when i do the following calculation

i = 16.989568650404

string.format("%02d:%02d",math.floor(i),math.ceil(math.fmod(i,1)*60)) 

the retrun is 16.60 which is correct but is not a time, so i need to round it but am unsure how to do that. if someone could be so kind and show me how to accomplish that please?

 

many thanks for all your contributions it really helps.

[jgab 2,642]

On 12/30/2021 at 11:01 AM, jgab said:

function decTime2StringMinutes(a)
  return string.format("%02d:%02d",math.floor(a),math.floor(0.5+math.fmod(a,1)*60))
end

Didn’t this work?