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 ":5
".
How can I correct this formula so that if it is single digits, it will show as ":05
"?
Is there a better way to capture this data? I did not want to capture the date, only the time.
Thank you,