Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want my worksheet to display the following time format....
Cell A.....Start time in Hours/Minutes eg 08.50 Cell B....Finish Time in Hours/Minutes eg 17.35 Cell C would = Cell B - Cell A .....showing the Hours/Minutes someone is at work. I dont need to display the seconds as we arent that picky. Im using UK time too Thanks for any help... Dave :) P.S. I did try to post this earlier but it seems to have disappeared - if both somehow manage to appear then my apologies cos I didnt mean to "multi Post" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
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 |