![]() |
help with date and time
I need to be able to read the time logged in (coloum b) to the time out (coloum c) and insert the time diffrence in (coloum d) with respect to the date in (coloum a) and then in (coloum e) i need to multiply the total of coloum d to a specified total "ie R12.50" to give me the total amount of time done and the the total amount in cost value I have being batteling with the time value i tried the the formular under "preforming time calculations when dealing with both time and date" please can you give me a little assistance thanx wayne -- wayne visser ------------------------------------------------------------------------ wayne visser's Profile: http://www.excelforum.com/member.php...o&userid=24292 View this thread: http://www.excelforum.com/showthread...hreadid=379005 |
Not sure I understand, but this might help: See encl. pictu http://www.excelforum.com/attachment...tid=3497&stc=1 Ola +-------------------------------------------------------------------+ |Filename: Clipboard01.jpg | |Download: http://www.excelforum.com/attachment.php?postid=3497 | +-------------------------------------------------------------------+ -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=379005 |
All times are GMT +1. The time now is 06:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com