Parse time

[datalogs1020]

Hi,

I need to create a new column minute and seconds based on the time lapse column.

I tried using the extract, but it doesn't seem to work in all cases . (ie, sometimes, it says "minute" or "minutes" or no minutes at all)

Can someone help me please? Newbie here.

Thank you!

Table1
Time lapse	minute	seconds
25 minutes, 10 seconds	25	10
1 minute	1
23 seconds	0	23

[MauriceMecowe]

Hi Datalogs1020,

It depends on the formate of your Time lapse column. If it's always the same structure, you can use a LEFT or RIGHT function to extract the correct value per column and use an ISBLANK for 0. If the format of Time Lapse differs per entry, I don't think this is possible