Calculate toal hours

[Vinu]

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

 

[Mike H]

Try

=B1-A1

format as [hh]:mm

Mike

 

[Peo Sjoblom]

=B1-A1

format as [h]:mm

--


Regards,


Peo Sjoblom

 

[David Biddulph]

=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.

 

[Vinu]

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.

=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

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

 

[David Biddulph]

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

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.

=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

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