TIME FUNCTION

more information about what you are trying to do would help.

most likely you want to have a column of time and they a formula to show the output for all those time values but had to get into any specifics without more information.

try sharing a sheet/workbook (if not here, put in an online site like onedrive or google or dropbox and share a link to it)

post sample data / tables or at least images

please do not share any confidential or private information (e.g. replace real names/ids/phone#/etc with fake info)