Subtracting Time and being alerted when the result is longer than a preset time

**piczim** · 10-18-2016, 01:12 PM

I have attached a spreadsheet. I have been monitoring the GSM cell phone signal in 5 minute intervals.

I would like to subtract the times between two notifications and then be alerted if its longer than 5minutes.

I don't know how to subtract time and not sure if there is a way to be notified if the time is longer than 5 minutes.

**alansidman** · 10-18-2016, 01:32 PM

In C5, type =ROUND((A3-A4)*1440,2) and copy down. This will give you the minute intervals. You can use conditional formatting to highlight values greater than 5.0

**piczim** · 10-18-2016, 01:50 PM

Thank you very much wow it works but I am not sure I follow.

How does the formula distinguish between the date and time which is in Column A?

I understand the ,2 is the rounding it to 2 decimal places.

why do you multiply the result of the subtraction by 1440

Thanks for the help

**piczim** · 10-18-2016, 01:51 PM

Originally Posted by alansidman

In C5, type =ROUND((A3-A4)*1440,2) and copy down. This will give you the minute intervals. You can use conditional formatting to highlight values greater than 5.0

Thank you very much wow it works but I am not sure I follow.

How does the formula distinguish between the date and time which is in Column A?

I understand the ,2 is the rounding it to 2 decimal places.

why do you multiply the result of the subtraction by 1440

Thanks for the help

**alansidman** · 10-18-2016, 01:59 PM

Here is a clear tutorial on Dates and Time. It should make clear how they work in Excel.

http://www.cpearson.com/excel/datetime.htm

Subtracting Time and being alerted when the result is longer than a preset time

LinkBack

Thread Tools

Rate This Thread

Display

Subtracting Time and being alerted when the result is longer than a preset time

Re: Subtracting Time and being alerted when the result is longer than a preset time

Re: Subtracting Time and being alerted when the result is longer than a preset time

Re: Subtracting Time and being alerted when the result is longer than a preset time

Re: Subtracting Time and being alerted when the result is longer than a preset time

Thread Information

Users Browsing this Thread

Similar Threads

Time sheets: Subtracting time based on the contents of another cell

[SOLVED] Adding / Subtracting TIME VAULES / UNITS (Not time of Day) - I'm lost ... [RESOLVED]

[SOLVED] Subtracting hours from a shift start time to show time in other time zones

[SOLVED] On Time Delivery subtracting hold time

converting military time to EDT and subtracting time from one cell to another

[SOLVED] How do I calculate time between 2 dates/times subtracting the time over weekends?

Formula for subtracting earlier time from later time in the 24 hour clock

Bookmarks

Bookmarks

Posting Permissions