2
votes
2answers
209 views

Minute:Second to seconds in Excel

I'm trying to work out how many seconds there are in a given time range. So for instance if I have the following times: 16:36:00 - 16:37:38 I need to the value of 98 seconds to be placed within a ...
4
votes
4answers
13k views

How do I calculate the difference between two time values in Excel?

Using Excel 2007, how do I calculate the time difference by entering a start time an end time What format do I use in the cells where the time is? For example, I'd like to be able to enter 0800 ...
5
votes
4answers
5k views

Work with hours and minutes in Excel 2007

I'm working on a spreadsheet that holds phone calls durations. So, each call (row) has a value like 00:01:30, 01:02:12, etc. When I sum the duration column, it will give me something like 687:23:42. ...
0
votes
3answers
3k views

Excel 2007 time miliseconds operations

I am using Excel 2007 and I am trying to subtract these two values: 11:27:55.428 11:28:09.813 I have tried to format both as time and as "hh:mm:ss.000" and every time I try to subtract them I get ...
4
votes
4answers
22k views

How to calculate hours and minutes between two time periods?

I’m working on a very simple time sheet for my work in Excel 2007, but I have run into trouble about calculate the hours and minutes between two time periods. I have a field: timestart which could be ...