Convert time cell

G

Gareth

Cell D35 on sheet1 is formatted as time ([hh:mm]). It can
contain anything from 00:00 to 123:45

What I want to do is round the time to the nearest half an
hour and then convert it to text. For example, if D35 had
10:15 (0.427083) in it then I want B6 on sheet2 to be 10:30

Any help gratefully received.

Gareth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding Time down 4
single cell time entry as time - time; Ever seen this? 12
Adjusting time data to nearest ten minute block 2
Converting Time 3
calculating time, overtime in excel [h]:mm format 4
If then statement based on time of day 3
Add Hours by Looping through Data Q 27
Extract time from date 4

Top