| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Time with a number value
I want to add a cell(number value) to a cell that is formatted to a time.
A1= 15 A2= 7:30AM A3= (7:30AM + 15{mins}) Result to be 7:45AM How can i do this ?? Corey.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating Time with a number value
Try
=A2+A1/1440 format as time if necessary -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Corey" wrote in message ... I want to add a cell(number value) to a cell that is formatted to a time. A1= 15 A2= 7:30AM A3= (7:30AM + 15{mins}) Result to be 7:45AM How can i do this ?? Corey.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating Time with a number value
beautiful.
Thanks "Peo Sjoblom" wrote in message ... Try =A2+A1/1440 format as time if necessary -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Corey" wrote in message ... I want to add a cell(number value) to a cell that is formatted to a time. A1= 15 A2= 7:30AM A3= (7:30AM + 15{mins}) Result to be 7:45AM How can i do this ?? Corey.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| Time format to number while keeping value | Excel Worksheet Functions | |||
| Calculating Time | Excel Discussion (Misc queries) | |||
| Display a number as Kilometers and k/hr & as Time | Excel Discussion (Misc queries) | |||
| Calculating Pay based on time of day hrs worked | Excel Worksheet Functions | |||
Linear Mode
