Excel help

I have a cell (A49) which computes NOW() customised to give the month (say for May it would show "5"). If I have a formula in another cell as "=((A49/12)*172.5)/3600" but the value is not 5 but 40325.5. How can I get the displayed month value across?

  VoG II 11:50 27 May 10

Try

=((MONTH(A49)/12)*172.5)/3600

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…