ExcelBanter - How do i get time in excel to calculate time between 20:00-03:45

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do i get time in excel to calculate time between 20:00-03:45 (https://www.excelbanter.com/excel-worksheet-functions/74980-how-do-i-get-time-excel-calculate-time-between-20-00-03-45-a.html)

peter

How do i get time in excel to calculate time between 20:00-03:45

Biff

How do i get time in excel to calculate time between 20:00-03:45

My best guess at what you want:

=B1-A1+(B1<A1)

Biff

"peter" wrote in message
...

JE McGimpsey

How do i get time in excel to calculate time between 20:00-03:45

one way:

A1: 20:00
B1: 03:45
C1: =MOD(B1-A1,1)

Format C1 as time.

In article ,
"peter" wrote:

All times are GMT +1. The time now is 05:53 PM.