I have a similar problem. I am a night shift worker, and my employer issues a time statement each week in the format of start time, end time, total. The problem is that in order to reproduce this in Excel, I must calculate accordingly. My result looks like this: 18:45, 08:30, 13:45. My time statement reads thus: 18:45, 08:30, 13.75. For the life of me, I can't get the calculation, (formula?) to same result. Help would be appreciated.
Thanks in advance
Jake
Thanks in advance
Jake