• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 390
  • Last Modified:

Short time auto-generated

I have an application people are using the 'scan into' work.

I want to store hours and minutes only, but am using "default value" of time$(); which returns long value (hh:mm:ss).  The reason it is important to not record seconds is that I want to ensure that a person isn't able to scan in twice (accidentally), so time is part of the key field.

how can I store a default value of hh:mm only?
0
TIgerV
Asked:
TIgerV
1 Solution
 
clarkscottCommented:
= format(YourValue, "hh:nn")

Scott C
0
 
TIgerVAuthor Commented:
Thank You!
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now