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?
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?
Hi!
A1 = 3:00 PM
B1 = 11:00 PM
=B1-A1+(A1>B1)
Format the cell as [h]:mm
Biff
"excelsior" <[email protected]> wrote in message
news:[email protected]...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks