Counting time in hours and minutes

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?
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
assuming no sessions go beyond midnight, it's just:

=end - start

format for elapsed time calculations is [ ]:

[h]:mm to stop the hours rolling over to days
[mm] to stop minutes rolling to hours etc
 

Watch MrExcel Video

Forum statistics

Threads
1,118,017
Messages
5,569,640
Members
412,284
Latest member
Daibear
Top