ExcelBanter

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - time (https://www.excelbanter.com/excel-discussion-misc-queries/172529-time.html)

learning

time

How do I write Excel formula for start 4am, end 12:35 pm, minus 30 minutes
Thanks
Pete

JE McGimpsey

time

XL stores times as fractional days, so one way:

=TIME(12,35,0) - TIME(4, 0, 0) - TIME(0, 30, 0)

another:

A1: 04:00 am
A2: 12:35 pm
A3: =A2-A1-TIME(0,30,0)

format A3 as a time, if necessary.

If the times may span midnight, use

=MOD(A2-A1-TIME(0,30,0),1)

In article ,
Learning wrote:

How do I write Excel formula for start 4am, end 12:35 pm, minus 30 minutes
Thanks
Pete

All times are GMT +1. The time now is 12:54 PM.