Time of Day Formula

Mindwatering Incorporated

Author: Tripp W Black

Created: 05/22/2006 at 10:08 PM

 

Category:
Notes Developer Tips
Formulas

Use the formula below in a drop-down combo box or list where the user can select time(s) between 12:00 AM midnight and 12:55 PM. The increment is 5 minutes based on the tmpmins variable.

tmppm:=" PM";
tmphrs:="12" : "1" : "2" : "3" : "4" : "5" : "6" : "7" : "8" : "9" : "10" : "11";
tmpmins:=":00" : ":05" : ":10" : ":15" : ":20" : ":25" : ":30" : ":35" : ":40" : ":45" : ":50" : ":55";
tmp1:=(tmphrs *+ tmpmins);
tmpam:= tmp1 + " AM";
tmppm:= tmp1 + " PM";
tmpam : tmppm

previous page