I asked a question yesterday about how to change decimal numbers into time and know I need to know how to SUM the time into total number of days, hours, and minutes.
For example, if I have B1 to B4 filled with 6:15 (being 6 hours and 15 minutes) when I go to sum them in B5 it says 1:00 hour.
Instead of it only saying the next days hour I need it to say 1 day and 1 hour.
How do I do that?
Thank you!
JR
For example, if I have B1 to B4 filled with 6:15 (being 6 hours and 15 minutes) when I go to sum them in B5 it says 1:00 hour.
Instead of it only saying the next days hour I need it to say 1 day and 1 hour.
How do I do that?
Thank you!
JR