Rounding time to nearest Hour

One way

=ROUND(A1/(1/24),0)*(1/24)

where A1 holds your time, format as time or you'll probably get a decimal
number

--
Regards,

Peo Sjoblom

(No private emails please)


"SierraRose" <[email protected]> wrote in message
news:[email protected]...
> In Excel, is there a way to round off time to the nearest hour. 6:10
> would
> become 6:00; 6:30 would be 7:00.

One way

=ROUND(A1/(1/24),0)*(1/24)

where A1 holds your time, format as time or you'll probably get a decimal
number

--
Regards,

Peo Sjoblom

(No private emails please)


"SierraRose" <[email protected]> wrote in message
news:[email protected]...
> In Excel, is there a way to round off time to the nearest hour. 6:10
> would
> become 6:00; 6:30 would be 7:00.

In Excel, is there a way to round off time to the nearest hour. 6:10 would
become 6:00; 6:30 would be 7:00.

One way

=ROUND(A1/(1/24),0)*(1/24)

where A1 holds your time, format as time or you'll probably get a decimal
number

--
Regards,

Peo Sjoblom

(No private emails please)


"SierraRose" <[email protected]> wrote in message
news:[email protected]...
> In Excel, is there a way to round off time to the nearest hour. 6:10
> would
> become 6:00; 6:30 would be 7:00.