|
Round result of sum function to quarter hour
How can I round the result to the nearest quarter hour?
=SUM(C14:P14)*24 |
Round result of sum function to quarter hour
Try this:
=ROUND((SUM(C14:P14)*24)/0.25,0)*0.25 -- Biff Microsoft Excel MVP "Trudy" wrote in message ... How can I round the result to the nearest quarter hour? =SUM(C14:P14)*24 |
Round result of sum function to quarter hour
PERFECT!!!!!!!
THANK YOU! "T. Valko" wrote: Try this: =ROUND((SUM(C14:P14)*24)/0.25,0)*0.25 -- Biff Microsoft Excel MVP "Trudy" wrote in message ... How can I round the result to the nearest quarter hour? =SUM(C14:P14)*24 |
Round result of sum function to quarter hour
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Trudy" wrote in message ... PERFECT!!!!!!! THANK YOU! "T. Valko" wrote: Try this: =ROUND((SUM(C14:P14)*24)/0.25,0)*0.25 -- Biff Microsoft Excel MVP "Trudy" wrote in message ... How can I round the result to the nearest quarter hour? =SUM(C14:P14)*24 |
| All times are GMT +1. The time now is 03:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com