Calculate Hours Minutes Sec in Zoho Creator Using Deluge

Calculate Hours Minutes Sec in Zoho Creator Using Deluge



  3. check_In = "8-Aug-2023 10:00:00".toDateTime().toLong();
  4. checkout = "8-Aug-2023 18:00:00".toDateTime().toLong();
  5. //difference = start.timeBetween(end);
  6. check_In = "8-Aug-2023 17:56:50".toDateTime().toLong();
  7. checkout = "8-Aug-2023 18:00:00".toDateTime().toLong();
  8. v_UnixSeconds = checkout - check_In;
  9. info v_UnixSeconds;
  10. info v_UnixSeconds;
  11. v_Days = floor((((v_UnixSeconds / 1000) / 60) / 60) / 24);
  12. v_Days = floor(v_UnixSeconds / 86400000);
  13. info v_Days;
  14. info v_UnixSeconds;
  15. v_UnixSeconds = v_UnixSeconds - v_Days * 1000 * 60 * 60 * 24;
  16. info v_UnixSeconds;
  17. v_Hours = floor(((v_UnixSeconds / 1000) / 60) / 60);
  18. info v_Hours;
  19. v_UnixSeconds = v_UnixSeconds - v_Hours * 1000 * 60 * 60;
  20. v_Minutes = floor((v_UnixSeconds / 1000) / 60);
  21. info v_Minutes;
  22. v_UnixSeconds = v_UnixSeconds - v_Minutes * 1000 * 60;
  23. v_Seconds = floor(v_UnixSeconds / 1000);
  24. info v_Seconds;
  25. //
  26. v_DayGrammar = if(v_Days == 1,"DAY","DAYS");
  27. v_HourGrammar = if(v_Hours == 1,"HR","HRS");
  28. v_MinGrammar = if(v_Minutes == 1,"MIN","MINS");
  29. v_SecGrammar = if(v_Seconds == 1,"SEC","SECS");
  30. //
  31. info v_Days + " " + v_DayGrammar + ", " + v_Hours + " " + v_HourGrammar + ", " + v_Minutes + " " + v_MinGrammar + ", " + v_Seconds + " " + v_SecGrammar;