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!
|