28/10/2009 10:00 am calculate transit hours 75 hrs = total calcula

A

ashwani

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
 
J

Jacob Skaria

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
 
C

Chaitanya Sagar

ashwani said:
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

Here's how you do it.

Let's say 28/10/2009 10:00 am is in A1, then I would write the following
formula in B1 = A1+(75/24)

Hope this helps.

Chaitanya
http://www.p2w2.com/chaitanya_sagar/index.php
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top