Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to subtract time cards in minutes in excel
can excel be set up to allow the subtracting of time cards that are in hours
and minutes and give the answer in the same format? |
#2
|
|||
|
|||
Hi!
A1 = 3:00 PM B1 = 11:00 PM =B1-A1+(A1B1) Format the cell as [h]:mm Biff "excelsior" wrote in message ... can excel be set up to allow the subtracting of time cards that are in hours and minutes and give the answer in the same format? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Calculation in Minutes only ? | Excel Worksheet Functions | |||
How do I make a time Stamp in excel? | Excel Discussion (Misc queries) | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
time interval calculations in excel | Excel Discussion (Misc queries) | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel |