Subracting times and dates
 

In Excel, how can I format a formula to subtract times? For example,
calculate the hours between 2300 hours and 0200 hours the following day.

Subracting times and dates
 

Fully qualify the date, i.e., enter the full date, Date & Time, e.g.,

3/21/2005 12:29 PM

Even if you format this cell just to view time, when you subtract the times,
it will show the correct difference in time, even if you should roll into the
next day.

http://HelpExcel.com

"Chrisbrot" wrote:

In Excel, how can I format a formula to subtract times? For example,
calculate the hours between 2300 hours and 0200 hours the following day.

Subracting times and dates
 

you also might need to format the result with the custom format of [h]:mm

Cheers
JulieD

"galimi" wrote in message
...
Fully qualify the date, i.e., enter the full date, Date & Time, e.g.,

3/21/2005 12:29 PM

Even if you format this cell just to view time, when you subtract the
times,
it will show the correct difference in time, even if you should roll into
the
next day.

http://HelpExcel.com

"Chrisbrot" wrote:

In Excel, how can I format a formula to subtract times? For example,
calculate the hours between 2300 hours and 0200 hours the following day.

Subracting times and dates
 

=MOD(B2-A2,1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Chrisbrot" wrote in message
...
In Excel, how can I format a formula to subtract times? For example,
calculate the hours between 2300 hours and 0200 hours the following day.