![]() |
|
#1
|
|||
|
|||
|
in the column "from" and "to", is let the user to key in their working time, format as 24hr
after that, in std, n/std, n/std2, each of it hv different time area std= 0800 - 1700 n/std=1701-2400 n/std2=2401-0759 i would like to do is calculate the hours that user had work. Example, from to std n/std n/std2 0900 0200 8 7 2 Can anyone help me with this? |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
a code to add altering time to cells
|
tesoke | Excel Programming | 3 | 12-17-2015 12:31 PM |
Format Painter doesn't work on Table Format?
|
Joey Cheung | Word Tables | 1 | 08-20-2014 02:24 AM |
How-TO format cells (FILL) by comparing cells
|
zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
how to gave comments to multiple cells at a time
|
gsrikanth | Excel Programming | 14 | 02-08-2012 04:53 AM |
How to get cells to calculate time?
|
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |