| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
28/10/2009 10:00 am calculate transit hours 75 hrs = total calcula
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
28/10/2009 10:00 am calculate transit hours 75 hrs = total calcula
"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 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate total pay from pay rate times hours and minutes | Excel Discussion (Misc queries) | |||
| Calculate time with a break and total hours | Excel Worksheet Functions | |||
| Function to calculate total hours worked in one week. | Excel Worksheet Functions | |||
| How do I calculate total weekly hours for payroll in Excel? | Excel Discussion (Misc queries) | |||
| How do I calculate total hours by rate of pay? | Excel Worksheet Functions | |||
Linear Mode
