Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtract hours from a time and get the correct time
I am trying to subtract 7 hrs from different times entered and get the
correct time. It works fine until it goes back to the prior day. How do I get it to display correctly? I am using Excel in Office 2007. I entered =1:18-7:00 and have a cell format of hh:mm AM/PM |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtract hours from a time and get the correct time
Assuming that you have 1:18 in A1 and 7:00 in B1 then try:
=MOD(A1-B1,1) for all your subtractions. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "casey" wrote in message ... I am trying to subtract 7 hrs from different times entered and get the correct time. It works fine until it goes back to the prior day. How do I get it to display correctly? I am using Excel in Office 2007. I entered =1:18-7:00 and have a cell format of hh:mm AM/PM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I subtract 8 business hours from a date/time value? | Excel Discussion (Misc queries) | |||
How do you subtract time as in a timecard to calculate hours work | Excel Worksheet Functions | |||
Time/Date subtract 24 hours | Excel Discussion (Misc queries) | |||
Subtract time between certain days/work hours? | Excel Worksheet Functions | |||
template or formula for start time -finish time -total hours ple | New Users to Excel |