28/10/2009 10:00 am calculate transit hours 75 hrs = total calcula
In cell A1 if you have the date and time in excel date/time format use the
below formula in cell B1 which adds up 75 hours to the date/time in cell A1
=A1+(75/24)
If this post helps click Yes
---------------
Jacob Skaria
"ashwani" wrote:
i want to know how to calculate date time in hours
suppose 28/10/2009 10:00 am calculate transit hours 75 hrs = total calculate
the date & time pls help n suggest
|