View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joec[_2_] joec[_2_] is offline
external usenet poster
 
Posts: 14
Default Calculating the number of minutes between days

=A1-B1, Format Custom as [m] will work fine but remember to format your
source cells how you want them to display. Do not type am or pm if entering
time.
--
joec


"Niek Otten" wrote:

=A1-B1, Format Custom as [m]

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jennifer Duffer" wrote in message
...
|I need to calculate the number of minutes between two times on two different
| days.
|
| For example:
|
| 2/6/2008 12:35 p.m.
| 2/8/2008 4:17 a.m.
|
| Any thoughts or direction I should go?
|
| Thanks much in advance!