Hello Everyone -
I have a system at work that spits out total time that an employee has been logged in (to a system), in the format of Days:Hours:Minutes:Seconds. This format does me no good so I convert it to either total Hours or Total Minutes.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
For example, 4:13:36:07 would be 4 days, 13 hours, 36 minutes, 7 seconds. Is there a formula or way to have Excel convert 4:13:36:07 into just total hours OR total minutes? <o></o>
<o></o>
I have had to do the calculations manually for several months now and I am about to pull my hair out. Any assistance would be GREATLY appreciated!<o></o>
<o></o>
Thanks,<o></o>
Pat<o></o>
I have a system at work that spits out total time that an employee has been logged in (to a system), in the format of Days:Hours:Minutes:Seconds. This format does me no good so I convert it to either total Hours or Total Minutes.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
For example, 4:13:36:07 would be 4 days, 13 hours, 36 minutes, 7 seconds. Is there a formula or way to have Excel convert 4:13:36:07 into just total hours OR total minutes? <o></o>
<o></o>
I have had to do the calculations manually for several months now and I am about to pull my hair out. Any assistance would be GREATLY appreciated!<o></o>
<o></o>
Thanks,<o></o>
Pat<o></o>
Last edited: