I have two columns in SharePoint that are each Single Line of Text columns that require the user to enter the start and end time of an audit, utilizing a 24-hour clock.
For example, the User enters "
14:00" into start time and "
14:26" into end time. I then created a Total Time Taken column that utilizes this formula:
=CONCATENATE(TEXT(HOUR([FMC Audit End Time]-[FMC Audit Start Time]),"#"),":",TEXT(MINUTE([FMC Audit End Time]-[FMC Audit Start Time]),"#"))
The problem is that if the start time is
14:00 and the end time is
14:05, it reflects the response as "
How can I correct this formula so that if it is single digits, it will show as "
Is there a better way to capture this data? I did not want to capture the date, only the time.