here's what i have...
note the time should read 06:42. My goal is to have it read "1 - hh:mm" if greater than 24 hours. When I change the blue cells (A1 & A2), it just rolls over without the day.
here's what i have...
note the time should read 06:42. My goal is to have it read "1 - hh:mm" if greater than 24 hours. When I change the blue cells (A1 & A2), it just rolls over without the day.
Last edited by Emil240; 11-26-2009 at 03:10 AM. Reason: updated for clarity
To be more specific, when I attempted the format suggested it also alters the time to "0 - 12:42". So not only is it not rolling over, it is also displaying the incorrect time.
Here is my most recent example.
Thanks in Advance,
Siv
Last edited by Emil240; 11-26-2009 at 03:23 AM. Reason: to be more specific
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks