how can we put if-condition for not getting zero-second on the cell?

**sagarkarki69** · 11-20-2019, 02:49 AM

I'm generating the time in the excel and copying it in another software but the case is that software doesn't support zero-second this is why I want to generate the time but not having zero seconds. format I am using for time is hh:mm:ss, and am using formula =B2+TIME(0,RANDBETWEEN(14,18),RANDBETWEEN(7,17)) where B2 has the original time and am adding 14-25 minutes in it where I don't want zero seconds to come in.

**Keebellah** · 11-20-2019, 04:20 AM

Hi, welcome to the forum.
The just pass the hours and minutes and not the seconds

**sagarkarki69** · 11-20-2019, 07:07 AM

i could do that but the matter is second is compulsory, just the thing is i want second but not the **:**:00.

**Aardigspook** · 11-20-2019, 07:55 AM

You could use a helper column to check if there are 0 seconds, then add 1 second if true. Then pass the results from the helper column to your other software.
For example, if your formula is in C2, put this in D2:

Formula:

Please Login or Register  to view this content.

Of course, as you are using RandBetween, the results will keep changing, so if you don't have too many results, you could instead just press F9 to recalculate until you don't have zero seconds.

**Aardigspook** · 11-22-2019, 05:35 PM

Thanks for the rep. If that means that you're happy that your question has been answered, then please take a moment to mark the thread as Solved so others know there's an answer here (instructions are in my sig). Thanks.

Edit: thank you

how can we put if-condition for not getting zero-second on the cell?

LinkBack

Thread Tools

Rate This Thread

Display

how can we put if-condition for not getting zero-second on the cell?

Re: how can we put if-condition for not getting zero-second on the cell?

Re: how can we put if-condition for not getting zero-second on the cell?

Re: how can we put if-condition for not getting zero-second on the cell?

Re: how can we put if-condition for not getting zero-second on the cell?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] IF FORMULA to set condition for cell to display 0 when condition is met blank when not met

[SOLVED] Color a cell If 2 other cells meet condition, undo cell color if third cell meet condition

Add validation list on condition, remove list upon condition --> for one cell value

open a comment to cell range upon true condition then removing comment on false condition

How to show the inserted shapes in a particular cell based on cell value meets a condition

cell colours for every 15th cell with data (condition formatting and Macro)

Select worksheet based on condition & populate cell based on condition

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions