Expand my Community achievements bar.

Gary_D__Cooper
Gary_D__Cooper
Offline
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • Any thoughts?

    Type

    Questions

    Views

    477

    Likes

    0

    Replies

    0
  • I have done what you've suggested and the input fields are set to time with a format of time{h:MM A}. It seems to just not calculate with this.var fullTime = 0 if (Table1.Row4.Cell2 ne null and Table1.Row5.Cell2 ne null) then if (Time2Num(Table1.Row4.Cell2.formattedValue, "HH:MM A") lt Time2Num(Tab...

    Type

    Questions

    Views

    478

    Likes

    0

    Replies

    0
  • I've noticed that it might have to deal with the seconds. When you try to do calculations they need the seconds for it to work, but when a user enters 8:00 AM there's no way to add the 00 to the end of the 8:00. To do calculations you need it in the format of 8:00:00 AM.

    Type

    Questions

    Views

    476

    Likes

    0

    Replies

    0
  • Maybe if I gave you an example it might help.Start 8:00 AMStop Start Lunch Start 12:00 PMLunch End 1:00 PMStop Start End 5:00 PMTotal Hours 8.0ORStart 7:00 AMStop Start Lunch Start 12:00 PMLunch End 1:00 PMStop Start End 6:00 PMTotal Hours 10.0

    Type

    Questions

    Views

    476

    Likes

    0

    Replies

    0
  • I tried to implement what you suggested, but now it just constantly shows a 0. Here is what I added to my FormCalc;var fullTime = 0if (Table1.Row4.Cell2 ne null and Table1.Row5.Cell2 ne null) then if (Time2Num(Table1.Row4.Cell2.formattedValue, "HH:MM") lt Time2Num(Table1.Row5.Cell2.formattedValue, "...

    Type

    Questions

    Views

    477

    Likes

    0

    Replies

    0
  • I've got a Form where I have a table with 8 fields and 1 field that calculates total hours worked. Each field the user needs to enter a valid time 8:00 AM or 1700, which will be converted to 5:00 PM. I'm trying to come up with a FormCalc formula that will give me the total hours worked.This is what ...

    Type

    Questions

    Views

    1.2K

    Likes

    0

    Replies

    8
Top badges earned by Gary_D__Cooper
Customize the badges you want to showcase on your profile