| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subracting times and dates
In Excel, how can I format a formula to subtract times? For example,
calculate the hours between 2300 hours and 0200 hours the following day. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Subracting times and dates
Fully qualify the date, i.e., enter the full date, Date & Time, e.g.,
3/21/2005 12:29 PM Even if you format this cell just to view time, when you subtract the times, it will show the correct difference in time, even if you should roll into the next day. http://HelpExcel.com "Chrisbrot" wrote: In Excel, how can I format a formula to subtract times? For example, calculate the hours between 2300 hours and 0200 hours the following day. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Subracting times and dates
you also might need to format the result with the custom format of [h]:mm
Cheers JulieD "galimi" wrote in message ... Fully qualify the date, i.e., enter the full date, Date & Time, e.g., 3/21/2005 12:29 PM Even if you format this cell just to view time, when you subtract the times, it will show the correct difference in time, even if you should roll into the next day. http://HelpExcel.com "Chrisbrot" wrote: In Excel, how can I format a formula to subtract times? For example, calculate the hours between 2300 hours and 0200 hours the following day. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Subracting times and dates
=MOD(B2-A2,1)
-- HTH RP (remove nothere from the email address if mailing direct) "Chrisbrot" wrote in message ... In Excel, how can I format a formula to subtract times? For example, calculate the hours between 2300 hours and 0200 hours the following day. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate times between dates and times in Excel | Excel Discussion (Misc queries) | |||
| Subracting Time. | Excel Worksheet Functions | |||
| adding and subracting credits | Excel Worksheet Functions | |||
| Dates and times with PST,PDT | Excel Worksheet Functions | |||
| Subracting Dates to come up with the # of days between them | Excel Worksheet Functions | |||
Linear Mode
