hollyequine
New Member
- Joined
- Mar 2, 2010
- Messages
- 11
Hi there, I am data dumping from our timekeeping system into Excel 2003. I have associates who worked 41 hours and 55 minutes (41.55) and some that worked 22 hours and 10 minutes (22.10).
Question 1:
How do I format so Excel reads this as 41:55 and 22:10, respectively (NOT in minutes and seconds, I need hours and minutes...)
Question 2:
I need to add these two hour sections together and have Excel recognize the TOTAL time as 64:05 NOT 63.65)
Help please!!
Question 1:
How do I format so Excel reads this as 41:55 and 22:10, respectively (NOT in minutes and seconds, I need hours and minutes...)
Question 2:
I need to add these two hour sections together and have Excel recognize the TOTAL time as 64:05 NOT 63.65)
Help please!!
