thesuggs76
Board Regular
- Joined
- Nov 15, 2006
- Messages
- 247
I am subtracting dates to work out the length of time. In many of the instances the time is more than 24 hours I would like the time to be displayed in Hours:min:ss so it would be 48:12:12 but I cant get it too work
Any suggestions, every time I do it I'm getting the 24/01/1990 11:20:38. I understand the first part is Excels way of putting number into time, but it would be best if it were purely in hours
Thanks
Any suggestions, every time I do it I'm getting the 24/01/1990 11:20:38. I understand the first part is Excels way of putting number into time, but it would be best if it were purely in hours
Thanks