0

Can I format my time to "number"

Hello Everyone

I am not sure if this is exactly a number, but can I format my time to appear as follow:

10:00 => 10.00

10:15 => 10.25

10:30 => 10.50

10:45 => 10.75

7 replies

null
    • George_Tanev
    • 4 yrs ago
    • Reported - view

    No ideas or it's not possible?

    • Nick
    • 4 yrs ago
    • Reported - view

    This gives you the above results:

    number(TimeField) / 3600000

      • gvibex
      • 5 mths ago
      • Reported - view

      THANK YOU!

    • George_Tanev
    • 4 yrs ago
    • Reported - view

    Thank you!

    Just a small dumm question - how can I format it to be 10.00 in the print form (PDF) instead of only 10

    • Nick
    • 4 yrs ago
    • Reported - view

    Screen Shot 2020-03-16 at 19.34.19

    • George_Tanev
    • 4 yrs ago
    • Reported - view

    Yes - this I know.

    The question was - if I want to change the format ONLY for the PDF file, that is created in the time of printing - how can I do it. It has to be writen...

    • Nick
    • 4 yrs ago
    • Reported - view

    If I understand you correctly...

    Υou have 2 fields, one with a time format of 10:45 and a calculation field of 10.75.
    Use only one (the desired) field in the print form.

Content aside

  • 5 mths agoLast active
  • 7Replies
  • 913Views
  • 1 Following