Hey everyone! I’m trying to figure out how to use Google Sheets to calculate the difference between two times in minutes. For instance, if I have 9:15 and 9:30, I want the result to show 15 minutes. I’ve been messing around with different formulas but can’t seem to get it right. Does anyone have a simple way to do this? I’m not great with spreadsheet formulas, so a straightforward explanation would be really helpful. Thanks in advance for any tips or tricks you can share!
Here’s a straightforward method I’ve used successfully:
Enter your start time in one cell (for example, A1) and the end time in another (such as B1). Then use the following formula:
=ROUND((B1-A1)2460,0)
This formula converts the time difference to minutes and rounds it to the nearest whole number. Multiplying by 24 changes the value from days to hours, and multiplying by 60 converts hours to minutes.
For times that cross midnight—say, from 11:30 PM to 12:30 AM—you can adjust the formula by adding 1 to the end time:
=ROUND((B1+1-A1)2460,0)
This method has consistently worked well.
hey alex, try this: =DATEDIF(A1,B1,“m”)+MOD(B1-A1,1)*1440
put start time in A1, end time in B1. it’ll work for times across midnight too. pretty handy and simple imo. lmk if u need more help!
I’ve encountered this issue myself and found a simple solution that works well. First, make sure your start and end times are placed in separate cells (for example, A1 and B1). Then use the formula =(B1-A1)*1440 to convert the difference into minutes, since there are 1440 minutes in a day.
If the end time is earlier than the start time, such as 11:00 PM to 1:00 AM, adjust the formula by adding 1 to B1 to handle the change in day. This method has reliably worked in my projects over time.