Calculating time difference over midnight!

  • Thread starter Thread starter sygazelle
  • Start date Start date
S

sygazelle

I have read all of the tips and tricks to try to get an answer withou
bothering anyone and I have come up empty.

Here is my specific question:

How do I calculate the time duration in minutes between two times whe
the first time is before midnight and the second time is afte
midnight? For example, how do I calculate the time difference i
minutes between 11:00PM and 1:37AM the next the next day?

Any help is appreciated
 
sygazelle said:
I have read all of the tips and tricks to try to get an answer without
bothering anyone and I have come up empty.

Here is my specific question:

How do I calculate the time duration in minutes between two times when
the first time is before midnight and the second time is after
midnight? For example, how do I calculate the time difference in
minutes between 11:00PM and 1:37AM the next the next day?

Any help is appreciated.
Click to expand...

Assuming first time is in A2 and the later time is in B2 put this in C2
=B2-A2+(B2<A2) and format the cell as [mm] .
 
I think you must enter the full date & time for each of these and mak
sure they are formatted as "Time". Assuming that these two times ar
in cells A1 & B1, in C1 (formatted as number) enter the formula
"=(B1-A1)*24". This will give you the hours in decimal form (in thi
case 2.62 hrs). If you want it in minutes then the formula is
"=(B1-A1)*24*60" (this = 157 minutes)
 
As I dont get to answer many questions, I thought I would give you my way of
doing this.
I simply enter the time as 25:30 for 12.30am or 26:30 for 1.30 am. The cell
can be formatted to read 12.30am or 1.30am etc and the time difference is
calculated correctly.
 
Back
Top