Posted to microsoft.public.excel.misc

Steve[_5_] Steve[_5_] is offline

external usenet poster

Posts: 5

Day Calculation Error

BRILLIANT, Thank you

"Rick Rothstein (MVP - VB)" wrote:

Actually I have the formating at custom dd "Days," hh" Hours"

If formatted General yes I get 63 days after rounding. Is there anyway to
re-format showing days and hours, but keep the "General" construct?

Maybe use this formula instead of the one you posted and leave the cell's
format as General.

=INT(NOW()-F32)&" Days, "&ROUND((NOW()-F32-INT(NOW()-F32))*24,0)&" Hours"

Rick

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculation Error?	Wei Ming from singapore	Excel Discussion (Misc queries)	3	January 3rd 07 12:39 PM
Excel calculation error?	Mike	Excel Discussion (Misc queries)	1	June 8th 06 04:36 PM
Calculation Error?	Randy Sp	Excel Discussion (Misc queries)	1	March 17th 06 08:27 PM
Re-Calculation error	5 Star	Excel Discussion (Misc queries)	2	June 16th 05 05:05 PM
calculation error	happyearth	Excel Worksheet Functions	2	June 16th 05 05:59 AM

All times are GMT +1. The time now is 12:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us