Dates and ROUND

[jarl1947]

I'm doing some calculations using dates and need to express the results to the nearest half day. Can I use the ROUND function to do this? Ideally, I'd like to be able to produce results which show the half day only where applicable and just the full days in other cases e. g. 23 days or 23.5 days not 23.00 days or 23.50 days.

Thanks in advance

 

[Andrew Poulsom]

Assuming your dates are in A1 and A2:

=MROUND(A2-A1,0.5)

formatted as 0.0

 

[Mala]

Andrew, you beat me to it

Here's some more info that might be helpful-

If you see error on entering Andrew's formula, do Tools>Add-ins and from the Add-ins list select 'Analysis Toolpack' to load the add-in. Hit F9 to recalculate the workbook.

If you do not see the 'Analysis Toolpack' in the add-ins list you need to update your Excel installation taking care to select option of installing the 'Analysis Toolpack' add-in.

 

[Aladin Akyurek]

On 2002-10-11 08:22, Mala wrote:
Andrew, you beat me to it

Here's some more info that might be helpful-

If you see error on entering Andrew's formula, do Tools>Add-ins and from the Add-ins list select 'Analysis Toolpack' to load the add-in. Hit F9 to recalculate the workbook.

If you do not see the 'Analysis Toolpack' in the add-ins list you need to update your Excel installation taking care to select option of installing the 'Analysis Toolpack' add-in.

It can also be computed with the Analysis Toolpak...

=ROUND((formula-that-computes-days-to-be-rounded)/0.5)*0.5

The OP didn't tell which formula is used to compute days like 23.1 or 23.8.

 

[jarl1947]

Andrew, Mala, Aladin

Thanks a lot. Used each one to good effect.