Share via

excel time

Anonymous
2022-07-14T22:22:19+00:00

I have a starting time for a process which iterates every 13.5 minutes . Assume the starting time is 8:30 AM . I need to add 13.5 minutes to 8:30 to get the time of the first iteration. In this way I can know the time of every iteration through the work day . It is a simple problem but I can't seem to get the formatting right . Can somebody younger than I figure this out? I'd appreciate that a lot.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-07-14T22:47:01+00:00

    Hi Lynn

    Assuming the starting time 8:30 AM is in cell A2

    Try the formula =A2+TIME(0,13,30) and format the cells as described in the picture below

    I hope this helps you and gives a solution to your problem

    Do let me know if you need more help

    Regards

    Jeovany

    Was this answer helpful?

    0 comments