LinkBack URL
About LinkBacks
Put the numbers in two separate cells, subtract normally, and format the result as [h]:mm
If you want to do it in one cell (but why?), you can enter it as ="9:00 PM" - "11:00 AM"
---A---- ---B--- --C-- ----D----- 1 11:00 AM 9:00 PM 10:00 C1: =B1-A1
Put the numbers in two separate cells, subtract normally, and format the result as [h]:mm
If you want to do it in one cell (but why?), you can enter it as ="9:00 PM" - "11:00 AM"---A---- ---B--- --C-- ----D----- 1 11:00 AM 9:00 PM 10:00 C1: =B1-A1
Last edited by shg; 09-29-2008 at 03:40 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks