ThePhantom86
New Member
- Joined
- Dec 12, 2005
- Messages
- 2
This is a two part question:
1. Where I work we sometimes have to monitor the network and we have a spreadsheet to track this time. We have the cells to display as hh:mm and I'm looking for the total time it took. While it is easy to just count, is there a way to have a function spit it out. Example:
Start / End / Total
2:23 / 15:31 / ??
2. I do have a SUM function to count the time for months but if it goes over 24 hours, then it resets. Like if we monitored for 24 hours and 23 minutes and I did a function it would just display this, 0:23. It is possible to count past a 24 hour clock?
1. Where I work we sometimes have to monitor the network and we have a spreadsheet to track this time. We have the cells to display as hh:mm and I'm looking for the total time it took. While it is easy to just count, is there a way to have a function spit it out. Example:
Start / End / Total
2:23 / 15:31 / ??
2. I do have a SUM function to count the time for months but if it goes over 24 hours, then it resets. Like if we monitored for 24 hours and 23 minutes and I did a function it would just display this, 0:23. It is possible to count past a 24 hour clock?