Need to calculate total hours of two different date & time & difference
between day & time.
e.g A1= 8/15/2008 22:30
B1=8/20/2008 22:33
Output=?

Thanks in Advance

Try

=B1-A1

format as [hh]:mm

Mike

"Vinu" wrote:

Need to calculate total hours of two different date & time & difference
between day & time.
e.g A1= 8/15/2008 22:30
B1=8/20/2008 22:33
Output=?

Thanks in Advance

=B1-A1

format as [h]:mm

--


Regards,


Peo Sjoblom

"Vinu" wrote in message
...
Need to calculate total hours of two different date & time & difference
between day & time.
e.g A1= 8/15/2008 22:30
B1=8/20/2008 22:33
Output=?

Thanks in Advance

=B1-A1, and format as [h]:mm, if you want the output as hours and minutes in
Excel time format.
=(B1-A1)*24, and format as number or general, if you want decimal hours.
--
David Biddulph

"Vinu" wrote in message
...
Need to calculate total hours of two different date & time & difference
between day & time.
e.g A1= 8/15/2008 22:30
B1=8/20/2008 22:33
Output=?

Thanks in Advance

hi David,
Can you please help me in below example
e.9 A1= 8/15/2008 22:30 Open time
B1=8/20/2008 22:33 end time
need to find total hours time spent in minutes if it is beyond the SLA fo
4hrs in minutes.it would say false.
please provide me the soultion at the earliest.
"David Biddulph" wrote:

=B1-A1, and format as [h]:mm, if you want the output as hours and minutes in
Excel time format.
=(B1-A1)*24, and format as number or general, if you want decimal hours.
--
David Biddulph

"Vinu" wrote in message
...
Need to calculate total hours of two different date & time & difference
between day & time.
e.g A1= 8/15/2008 22:30
B1=8/20/2008 22:33
Output=?

Thanks in Advance

If you want to convert hours to minutes, multiply by 60.
If you want to test a value against a constant, and produce a result
depending on that test, use the IF function; details of the syntax of the
IF function are available in Excel help.
--
David Biddulph

"Vinu" wrote in message
...
hi David,
Can you please help me in below example
e.9 A1= 8/15/2008 22:30 Open time
B1=8/20/2008 22:33 end time
need to find total hours time spent in minutes if it is beyond the SLA fo
4hrs in minutes.it would say false.
please provide me the soultion at the earliest.
"David Biddulph" wrote:

=B1-A1, and format as [h]:mm, if you want the output as hours and minutes
in
Excel time format.
=(B1-A1)*24, and format as number or general, if you want decimal hours.
--
David Biddulph

"Vinu" wrote in message
...
Need to calculate total hours of two different date & time &
difference
between day & time.
e.g A1= 8/15/2008 22:30
B1=8/20/2008 22:33
Output=?

Thanks in Advance