Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time
I am trying to subtract a beginning time from an ending time. If a3 is the
beginning and a4 is the ending, how should I set up those celsl and what formula should I use to get the answer I would also like to total the total time column. . I would prefer not to use military time if at all possible since it would confuse the person who is inputting the times. thanks in advance bob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time
Bob,
Simply subtract them to get the difference but always later time - earlier time =B1-A1 The time format is irrelevant because that's just how you see it, the underlying vlaue of the time doesn't alter. Mike "bob" wrote: I am trying to subtract a beginning time from an ending time. If a3 is the beginning and a4 is the ending, how should I set up those celsl and what formula should I use to get the answer I would also like to total the total time column. . I would prefer not to use military time if at all possible since it would confuse the person who is inputting the times. thanks in advance bob |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time
Bob,
I should have added it gets slightly more complicated for time before/after midnight so a formula that copes with both is:- =(B1-A1+(B1<A1))*24 a1= start time b1 = end time "bob" wrote: I am trying to subtract a beginning time from an ending time. If a3 is the beginning and a4 is the ending, how should I set up those celsl and what formula should I use to get the answer I would also like to total the total time column. . I would prefer not to use military time if at all possible since it would confuse the person who is inputting the times. thanks in advance bob |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time
=Mod(B1-A1,1)
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "bob" wrote in message ... I am trying to subtract a beginning time from an ending time. If a3 is the beginning and a4 is the ending, how should I set up those celsl and what formula should I use to get the answer I would also like to total the total time column. . I would prefer not to use military time if at all possible since it would confuse the person who is inputting the times. thanks in advance bob |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time
Thanks
bob "bob" wrote in message ... I am trying to subtract a beginning time from an ending time. If a3 is the beginning and a4 is the ending, how should I set up those celsl and what formula should I use to get the answer I would also like to total the total time column. . I would prefer not to use military time if at all possible since it would confuse the person who is inputting the times. thanks in advance bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions |