If function

R

ramshad

New Member
Joined
Apr 9, 2016
Messages
3
if a cell shows FRIDAY, I need 12:00 in another cell</SPAN>
if it is SATURDAY, I need 15:00 in another cell</SPAN></SPAN>
if it is SUNDAY, MONDAY, TUESDAY, WEDNESDAY</SPAN></SPAN></SPAN>

[TABLE="class: MsoNormalTable, width: 771"]
<TBODY>[TR]
[TD="width: 1029, bgcolor: transparent, colspan: 13"][/TD]
[/TR]
[TR]
[TD="width: 169, bgcolor: transparent, colspan: 2"][/TD]
[TD="width: 65, bgcolor: transparent"][/TD]
[TD="width: 102, bgcolor: transparent"][/TD]
[TD="width: 114, bgcolor: transparent"][/TD]
[TD="width: 96, bgcolor: transparent"][/TD]
[TD="width: 102, bgcolor: transparent"][/TD]
[TD="width: 163, bgcolor: transparent, colspan: 2"][/TD]
[TD="width: 45, bgcolor: transparent"][/TD]
[TD="width: 25, bgcolor: transparent"][/TD]
[TD="width: 25, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 234, bgcolor: transparent, colspan: 3"][/TD]
[TD="width: 102, bgcolor: transparent"]<v:shapetype id=_x0000_t32 filled="f" path="m,l21600,21600e" o:oned="t" o:spt="32" coordsize="21600,21600"><v:path o:connecttype="none" fillok="f" arrowok="t"></v:path><o:lock shapetype="t" v:ext="edit"></o:lock></v:shapetype><v:shape style="Z-INDEX: 251665408; POSITION: absolute; MARGIN-TOP: 12.25pt; WIDTH: 371.25pt; HEIGHT: 63pt; VISIBILITY: visible; MARGIN-LEFT: 62.95pt; flip: x; mso-wrap-style: square; mso-width-percent: 0; mso-height-percent: 0; mso-wrap-distance-left: 9pt; mso-wrap-distance-top: 0; mso-wrap-distance-right: 9pt; mso-wrap-distance-bottom: 0; mso-position-horizontal: absolute; mso-position-horizontal-relative: text; mso-position-vertical: absolute; mso-position-vertical-relative: text; mso-width-relative: margin; mso-height-relative: margin" id=Straight_x0020_Arrow_x0020_Connector_x0020_2 strokeweight="2.25pt" strokecolor="#4579b8 [3044]" o:gfxdata="UEsDBBQABgAIAAAAIQC75UiUBQEAAB4CAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSRvU7DMBSF

dyTewfKKEqcMCKEmHfgZgaE8wMW+SSwc27JvS/v23KTJgkoXFsu+P+c7Ol5vDoMTe0zZBl/LVVlJ

gV4HY31Xy4/tS3EvRSbwBlzwWMsjZrlprq/W22PELHjb51r2RPFBqax7HCCXIaLnThvSAMTP1KkI

+gs6VLdVdad08ISeCho1ZLN+whZ2jsTzgcsnJwldluLxNDiyagkxOquB2Knae/OLUsyEkjenmdzb

mG/YhlRnCWPnb8C898bRJGtQvEOiVxjYhtLOxs8AySiT4JuDystlVV4WPeM6tK3VaILeDZxIOSsu

ti/jidNGNZ3/J08yC1dNv9v8AAAA//8DAFBLAwQUAAYACAAAACEArTA/8cEAAAAyAQAACwAAAF9y

ZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj39ubi6AgeJtl2G9m6vYx

jeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLBBhaZ4ljBkFLYSMl6oAm5

8IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZTVuvrxO59CNCmoj3vCwj

MfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAAACEA387MseYBAACyBAAA

HwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWyklN1u1DAQhe+ReAfL9zTZpWlD1GyF

llIuEK1Y+gAjx0ksnHFkm2z27Rnnb1erqoj2zj9zPp8zdnJz2zeaddI6ZTDnq4uYM4nCFAqrnD/9

+voh5cx5wAK0QZnzg3T8dvP+3Q1klYW2VoIRAV0GOa+9b7MocqKWDbgL00qkvdLYBjxNbRUVFvZE

bnS0juOrqAGFfHNEfQEP7I9Vr0BpI37LYgvYgSOkFtnpyuRRi7eTIcPu3ra79tEG5+JH92iZKnJO

nUNoqEU8mjamMppGZ6rqCOhL24R6U5asz/nHVXKVpAlnB7qNy/RTfJ2MPNl7Jqjg8pqWaZEJqkjj

eBXH04H1wz8Qor57GUI2Rzs0OLEoety1wSN22zA8T76ek++8BVXVnn221uzZ1iBK4Y1l66UnE2Du

yQnPTdzggJVatd+oA8PreGNrllSQtdb5e2kaFgY5d5Pfxeh4HnTfnR8dzoKQXiPb53ydJtT9MK8l

FHdYMH9o6dYhRB5jelD6mQ3yoXF4C3NU5w9ajuifsqRXRPc7Whi+IbnVlnWgCS6ERL8K+IFC1UFW

Kq0XYTyYelE41QepLEu6mv8RL4rhZINHcaPQ2OdO9/1suRzrx/RjagoyPazo7Gsdqqa/S/glnM43

fwEAAP//AwBQSwMEFAAGAAgAAAAhAJxOXiHiBgAAOhwAABoAAABjbGlwYm9hcmQvdGhlbWUvdGhl

bWUxLnhtbOxZT28bRRS/I/EdRntv4/+NozpV7NgNtGmj2C3qcbwe704zu7OaGSf1DbVHJCREQRyo

xI0DAiq1EpfyaQJ***R+Bd7M7K534jVJ2wgqaA7x7tvfvP/vzZvdy1fuRQwdEiEpjzte9WLFQyT2

+YTGQce7NRpcWPeQVDieYMZj0vHmRHpXNt9/7zLe8BlNxhyLySgkEUHAKJYbuOOFSiUba2vSBzKW

F3lCYng25SLCCm5FsDYR+AgERGytVqm01iJMY28TOCrNqM/gX6ykJvhMDDUbgmIcgfSb0yn1icFO

DqoaIeeyxwQ6xKzjAc8JPxqRe8pDDEsFDzpexfx5a5uX1/BGuoipFWsL6wbmL12XLpgc1IxMEYxz

odVBo31pO+dvAEwt4/r9fq9fzfkZAPZ9sNTqUuTZGKxXuxnPAsheLvPuVZqVhosv8K8v6dzudrvN

dqqLZWpA9rKxhF+vtBpbNQdvQBbfXMI3ulu9XsvBG5DFt5bwg0vtVsPFG1DIaHywhNYBHQxS7jlk

ytlOKXwd4OuVFL5AQTbk2aVFTHmsVuVahO9yMQCABjKsaIzUPCFT7ENO9nA0FhRrAXiD4MITS/Ll

EknLQtIXNFEd78MEx14B8vLZ9y+fPUHH958e3//p+MGD4/s/WkbOqh0cB8VVL7797M9HH6M/nnzz

4uEX5XhZxP/6wye//Px5ORDKZ2He8y8f//b08fOvPv39u4cl8C2Bx0X4iEZEohvkCO3zCAwzXnE1

J2PxaitGIabFFVtxIHGMtZQS/n0VOugbc8zS6Dh6dInrwdsC2kcZ8OrsrqPwMBQzRUskXwsjB7jL

OetyUeqFa1pWwc2jWRyUCxezIm4f48My2T0cO/HtzxLom1laOob3QuKoucdwrHBAYqKQfsYPCCmx

7g6ljl93qS+45FOF7lDUxbTUJSM6drJpsWiHRhCXeZnNEG/HN7u3UZezMqu3yaGLhKrArET5EWGO

G6/imcJRGcsRjljR4dexCsuUHM6FX8T1pYJIB4Rx1J8QKcvW3BRgbyHo1zB0rNKw77J55CKFogdl

PK9jzovIbX7QC3GUlGGHNA6L2A/kAaQoRntclcF3uVsh+h7igOOV4b5NiRPu07vBLRo4Ki0SRD+Z

iZJYXiXcyd/hnE0xMa0GmrrTqyMa/13jZhQ6t5Vwfo0bWuXzrx+V6P22tuwt2L3KambnRKNehTvZ

nntcTOjb35238SzeI1AQy1vUu+b8rjl7//nmvKqez78lL7owNGg9i9hB24zd0cqpe0oZG6o5I9el

Gbwl7D2TARD1OnO6JPkpLAnhUlcyCHBwgcBmDRJcfURVOAxxAkN71dNMApmyDiRKuITDoiGX8tZ4

GPyVPWo29SHEdg6J1S6fWHJdk7OzRs7GaBWYA20mqK4ZnFVY/VLKFGx7HWFVrdSZpVWNaqYpOtJy

k7WLzaEcXJ6bBsTcmzDUIBiFwMstON9r0XDYwYxMtN9tjLKwmCicZ4hkiCckjZG2ezlGVROkLFeW

DNF22GTQB8dTvFaQ1tZs30DaWYJUFNdYIS6L3ptEKcvgRZSA28lyZHGxOFmMjjpeu1lresjHSceb

wjkZLqMEoi71HIlZAG+YfCVs2p9azKbKF9FsZ4a5RVCFVx/W70sGO30gEVJtYxna1DCP0hRgsZZk

9a81wa3nZUBJNzqbFvV1SIZ/TQvwoxtaMp0SXxWDXaBo39nbtJXymSJiGE6O0JjNxD6G8OtUBXsm

VMLrDtMR9A28m9PeNo/c5pwWXfGNmMFZOmZJiNN2q0s0q2QLNw0p18HcFdQD20p1N8a9uimm5M/J

lGIa/89M0fsJvH2oT3QEfHjRKzDSldLxuFAhhy6UhNQfCBgcTO+AbIH3u/AYkgreSptfQQ71r605

y8OUNRwi1T4NkKCwH6lQELIHbclk3ynMquneZVmylJHJqIK6MrFqj8khYSPdA1t6b/dQCKluukna

BgzuZP6592kFjQM95BTrzelk+d5ra+CfnnxsMYNRbh82A03m/1zFfDxY7Kp2vVme7b1FQ/SDxZjV

yKoChBW2gnZa9q+pwitutbZjLVlca2bKQRSXLQZiPhAl8A4J6X+w/1HhM/sFQ2+oI74PvRXBxwvN

DNIGsvqCHTyQbpCWOIbByRJtMmlW1rXp6KS9lm3W5zzp5nJPOFtrdpZ4v6Kz8+HMFefU4nk6O/Ww

42tLW+lqiOzJEgXSNDvImMCUfcnaxQkaB9WOB1+TIND34Aq+R3lAq2laTdPgCj4ywbBkvwx1vPQi

o8BzS8kx9YxSzzCNjNLIKM2MAsNZ+g0mo7SgU+nPJvDZTv94KPtCAhNc+kUla6rO577NvwAAAP//

AwBQSwMEFAAGAAgAAAAhAJxmRkG7AAAAJAEAACoAAABjbGlwYm9hcmQvZHJhd2luZ3MvX3JlbHMv

ZHJhd2luZzEueG1sLnJlbHOEj80KwjAQhO+C7xD2btJ6EJEmvYjQq9QHCMk2LTY/JFHs2xvoRUHw

sjCz7DezTfuyM3liTJN3HGpaAUGnvJ6c4XDrL7sjkJSl03L2DjksmKAV201zxVnmcpTGKSRSKC5x

GHMOJ8aSGtHKRH1AVzaDj1bmIqNhQaq7NMj2VXVg8ZMB4otJOs0hdroG0i+hJP9n+2GYFJ69elh0

+UcEy6UXFqCMBjMHSldnnTUtXYGJhn39Jt4AAAD//wMAUEsBAi0AFAAGAAgAAAAhALvlSJQFAQAA

HgIAABMAAAAAAAAAAAAAAAAAAAAAAFtDb250ZW50X1R5cGVzXS54bWxQSwECLQAUAAYACAAAACEA

rTA/8cEAAAAyAQAACwAAAAAAAAAAAAAAAAA2AQAAX3JlbHMvLnJlbHNQSwECLQAUAAYACAAAACEA

387MseYBAACyBAAAHwAAAAAAAAAAAAAAAAAgAgAAY2xpcGJvYXJkL2RyYXdpbmdzL2RyYXdpbmcx

LnhtbFBLAQItABQABgAIAAAAIQCcTl4h4gYAADocAAAaAAAAAAAAAAAAAAAAAEMEAABjbGlwYm9h

cmQvdGhlbWUvdGhlbWUxLnhtbFBLAQItABQABgAIAAAAIQCcZkZBuwAAACQBAAAqAAAAAAAAAAAA

AAAAAF0LAABjbGlwYm9hcmQvZHJhd2luZ3MvX3JlbHMvZHJhd2luZzEueG1sLnJlbHNQSwUGAAAA

AAUABQBnAQAAYAwAAAAA

" type="#_x0000_t32" o:spid="_x0000_s1027"><v:stroke endarrow="open" startarrow="open"></v:stroke></v:shape><o:p></o:p>
[/TD]
[TD="width: 114, bgcolor: transparent"][/TD]
[TD="width: 96, bgcolor: transparent"][/TD]
[TD="width: 102, bgcolor: transparent"][/TD]
[TD="width: 163, bgcolor: transparent, colspan: 2"]DATE<o:p></o:p>
[/TD]
[TD="width: 218, bgcolor: transparent, colspan: 4"]Friday, April 01, 2016<o:p></o:p>
[/TD]
[/TR]
[TR]
[TD="width: 132, bgcolor: transparent"][/TD]
[TD="width: 102, bgcolor: transparent, colspan: 2"][/TD]
[TD="width: 102, bgcolor: transparent"][/TD]
[TD="width: 114, bgcolor: transparent"][/TD]
[TD="width: 96, bgcolor: transparent"][/TD]
[TD="width: 102, bgcolor: transparent"][/TD]
[TD="width: 163, bgcolor: transparent, colspan: 2"][/TD]
[TD="width: 45, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 173, bgcolor: transparent, colspan: 3"][/TD]
[/TR]
[TR]
[TD="width: 132, bgcolor: transparent"]
ملاحظات<o:p></o:p>​
[/TD]
[TD="width: 102, bgcolor: transparent, colspan: 2"]
التوقيع<o:p></o:p>​
[/TD]
[TD="width: 102, bgcolor: transparent"]
وقت الخروج<o:p></o:p>​
[/TD]
[TD="width: 114, bgcolor: transparent"]
التوقيع<o:p></o:p>​
[/TD]
[TD="width: 96, bgcolor: transparent"]
وقت الدخول<o:p></o:p>​
[/TD]
[TD="width: 102, bgcolor: transparent"]
الدائرة<o:p></o:p>​
[/TD]
[TD="width: 126, bgcolor: transparent"]
رقم التوظيف<o:p></o:p>​
[/TD]
[TD="width: 82, bgcolor: transparent, colspan: 2"]
الاســــــم<o:p></o:p>​
[/TD]
[TD="width: 173, bgcolor: transparent, colspan: 3"]
الرقم<o:p></o:p>​
[/TD]
[/TR]
[TR]
[TD="width: 132, bgcolor: transparent"]
REMARKS<o:p></o:p>​
[/TD]
[TD="width: 102, bgcolor: transparent, colspan: 2"]
SIGNATURE<o:p></o:p>​
[/TD]
[TD="width: 102, bgcolor: transparent"]
TIME OUT<o:p></o:p>​
[/TD]
[TD="width: 114, bgcolor: transparent"]
SIGNATURE<o:p></o:p>​
[/TD]
[TD="width: 96, bgcolor: transparent"]
TIME IN<o:p></o:p>​
[/TD]
[TD="width: 102, bgcolor: transparent"]
DIRECTORATE<o:p></o:p>​
[/TD]
[TD="width: 126, bgcolor: transparent"]
EMP. NO.<o:p></o:p>​
[/TD]
[TD="width: 82, bgcolor: transparent, colspan: 2"]
NAME<o:p></o:p>​
[/TD]
[TD="width: 173, bgcolor: transparent, colspan: 3"]
SR. NO.<o:p></o:p>​
[/TD]
[/TR]
[TR]
[TD="width: 132, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 102, bgcolor: transparent, colspan: 2"]
<o:p></o:p>​
[/TD]
[TD="width: 102, bgcolor: transparent"]
12:00<o:p></o:p>​
[/TD]
[TD="width: 114, bgcolor: transparent"]<o:p></o:p>
[/TD]
[TD="width: 96, bgcolor: transparent"]
7:00<o:p></o:p>​
[/TD]
[TD="width: 102, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 126, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 82, bgcolor: transparent, colspan: 2"]<o:p></o:p>
[/TD]
[TD="width: 173, bgcolor: transparent, colspan: 3"]
1<o:p></o:p>​
[/TD]
[/TR]
[TR]
[TD="width: 132, bgcolor: transparent"][/TD]
[TD="width: 102, bgcolor: transparent, colspan: 2"]
<o:p></o:p>​
[/TD]
[TD="width: 102, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 114, bgcolor: transparent"]<o:p></o:p>
[/TD]
[TD="width: 96, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 102, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 126, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 82, bgcolor: transparent, colspan: 2"]<o:p></o:p>
[/TD]
[TD="width: 173, bgcolor: transparent, colspan: 3"]
2<o:p></o:p>​
[/TD]
[/TR]
[TR]
[TD="width: 132, bgcolor: transparent"]<o:p></o:p>
[/TD]
[TD="width: 102, bgcolor: transparent, colspan: 2"]
<o:p></o:p>​
[/TD]
[TD="width: 102, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 114, bgcolor: transparent"]<o:p></o:p>
[/TD]
[TD="width: 96, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 102, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 126, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 82, bgcolor: transparent, colspan: 2"]<o:p></o:p>
[/TD]
[TD="width: 173, bgcolor: transparent, colspan: 3"]
3<o:p></o:p>​
[/TD]
[/TR]
[TR]
[TD="width: 132, bgcolor: transparent"][/TD]
[TD="width: 37, bgcolor: transparent"][/TD]
[TD="width: 65, bgcolor: transparent"][/TD]
[TD="width: 102, bgcolor: transparent"][/TD]
[TD="width: 114, bgcolor: transparent"][/TD]
[TD="width: 96, bgcolor: transparent"][/TD]
[TD="width: 102, bgcolor: transparent"][/TD]
[TD="width: 126, bgcolor: transparent"][/TD]
[TD="width: 37, bgcolor: transparent"][/TD]
[TD="width: 45, bgcolor: transparent"][/TD]
[TD="width: 25, bgcolor: transparent"][/TD]
[TD="width: 25, bgcolor: transparent"][/TD]
[TD="width: 123, bgcolor: transparent"][/TD]
[/TR]
</TBODY>[/TABLE]
<o:p></o:p>
[TABLE="class: MsoNormalTable, width: 788"]
<TBODY>[TR]
[TD="width: 169, bgcolor: transparent, colspan: 2"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 72, bgcolor: transparent"][/TD]
[TD="width: 126, bgcolor: transparent"][/TD]
[TD="width: 144, bgcolor: transparent"][/TD]
[TD="width: 146, bgcolor: transparent"][/TD]
[TD="width: 83, bgcolor: transparent"][/TD]
[TD="width: 51, bgcolor: transparent"][/TD]
[TD="width: 25, bgcolor: transparent"][/TD]
[TD="width: 25, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 240, bgcolor: transparent, colspan: 3"][/TD]
[TD="width: 72, bgcolor: transparent"][/TD]
[TD="width: 126, bgcolor: transparent"][/TD]
[TD="width: 144, bgcolor: transparent"][/TD]
[TD="width: 146, bgcolor: transparent"][/TD]
[TD="width: 83, bgcolor: transparent"]DATE<o:p></o:p>
[/TD]
[TD="width: 240, bgcolor: transparent, colspan: 4"]Saturday, April 02, 2016<o:p></o:p>
[/TD]
[/TR]
[TR]
[TD="width: 126, bgcolor: transparent"][/TD]
[TD="width: 114, bgcolor: transparent, colspan: 2"][/TD]
[TD="width: 72, bgcolor: transparent"][/TD]
[TD="width: 126, bgcolor: transparent"]
<v:shape style="Z-INDEX: 251663360; POSITION: absolute; TEXT-ALIGN: left; MARGIN-TOP: 9.05pt; WIDTH: 371.25pt; HEIGHT: 63pt; VISIBILITY: visible; MARGIN-LEFT: 17.05pt; LEFT: 0px; flip: x; mso-wrap-style: square; mso-width-percent: 0; mso-height-percent: 0; mso-wrap-distance-left: 9pt; mso-wrap-distance-top: 0; mso-wrap-distance-right: 9pt; mso-wrap-distance-bottom: 0; mso-position-horizontal: absolute; mso-position-horizontal-relative: text; mso-position-vertical: absolute; mso-position-vertical-relative: text; mso-width-relative: margin; mso-height-relative: margin" id=Straight_x0020_Arrow_x0020_Connector_x0020_1 strokeweight="2.25pt" strokecolor="#4579b8 [3044]" o:gfxdata="UEsDBBQABgAIAAAAIQC75UiUBQEAAB4CAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSRvU7DMBSF

dyTewfKKEqcMCKEmHfgZgaE8wMW+SSwc27JvS/v23KTJgkoXFsu+P+c7Ol5vDoMTe0zZBl/LVVlJ

gV4HY31Xy4/tS3EvRSbwBlzwWMsjZrlprq/W22PELHjb51r2RPFBqax7HCCXIaLnThvSAMTP1KkI

+gs6VLdVdad08ISeCho1ZLN+whZ2jsTzgcsnJwldluLxNDiyagkxOquB2Knae/OLUsyEkjenmdzb

mG/YhlRnCWPnb8C898bRJGtQvEOiVxjYhtLOxs8AySiT4JuDystlVV4WPeM6tK3VaILeDZxIOSsu

ti/jidNGNZ3/J08yC1dNv9v8AAAA//8DAFBLAwQUAAYACAAAACEArTA/8cEAAAAyAQAACwAAAF9y

ZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj39ubi6AgeJtl2G9m6vYx

jeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLBBhaZ4ljBkFLYSMl6oAm5

8IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZTVuvrxO59CNCmoj3vCwj

MfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAAACEAyuDoTOYBAACyBAAA

HwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWykVNtu1DAQfUfiHyy/0yTbLRuiZiu0

lPKAaMXCB4wcJ7FwxpFtstm/Z5zbrlZVEfTNY885c8547Nu7vtGsk9YpgzlPrmLOJApTKKxy/vPH

53cpZ84DFqANypwfpeN327dvbiGrLLS1EowY0GWQ89r7NosiJ2rZgLsyrUQ6K41twFNoq6iwcCDm

RkerOH4fNaCQb09Un8AD+23Vf1BpI37JYgfYgSNKLbLznUmjFq9nhgy7B9vu2ycblItv3ZNlqsg5

dQ6hoRbxaDqY0iiMLlDViaAvbRPyTVmyPufXqyRJr4nrmPN1kmw+bG5GPtl7JihhvUnWKW0yQRlp

HCdxPBWsH/9CIer7l0lI5iiHFmcSRY/7NmjEbheWl86T2fneW1BV7dlHa82B7QyiFN5Yliw9mQjm

npzxuYk3KGClVu0XmsdhOl7ZmsUVZK11/kGahoVFzt2kdxE61oPuq/OjwhkQ3Gtkh5yv0hvqfohr

CcU9FswfW7p1CJZHmx6UfuaAdGgcZmG26vxRy5H6uyxpiuh+RwnDG5I7bVkHmsiFkOiHLg4slB1g

pdJ6AcaDqBeBU36AyrKkq/kX8IIYKhs8gRuFxj5X3fez5HLMH92PrsnINFjRxWsdsqbfJXwJ5/H2

DwAAAP//AwBQSwMEFAAGAAgAAAAhAJxOXiHiBgAAOhwAABoAAABjbGlwYm9hcmQvdGhlbWUvdGhl

bWUxLnhtbOxZT28bRRS/I/EdRntv4/+NozpV7NgNtGmj2C3qcbwe704zu7OaGSf1DbVHJCREQRyo

xI0DAiq1EpfyaQJ***R+Bd7M7K534jVJ2wgqaA7x7tvfvP/vzZvdy1fuRQwdEiEpjzte9WLFQyT2

+YTGQce7NRpcWPeQVDieYMZj0vHmRHpXNt9/7zLe8BlNxhyLySgkEUHAKJYbuOOFSiUba2vSBzKW

F3lCYng25SLCCm5FsDYR+AgERGytVqm01iJMY28TOCrNqM/gX6ykJvhMDDUbgmIcgfSb0yn1icFO

DqoaIeeyxwQ6xKzjAc8JPxqRe8pDDEsFDzpexfx5a5uX1/BGuoipFWsL6wbmL12XLpgc1IxMEYxz

odVBo31pO+dvAEwt4/r9fq9fzfkZAPZ9sNTqUuTZGKxXuxnPAsheLvPuVZqVhosv8K8v6dzudrvN

dqqLZWpA9rKxhF+vtBpbNQdvQBbfXMI3ulu9XsvBG5DFt5bwg0vtVsPFG1DIaHywhNYBHQxS7jlk

ytlOKXwd4OuVFL5AQTbk2aVFTHmsVuVahO9yMQCABjKsaIzUPCFT7ENO9nA0FhRrAXiD4MITS/Ll

EknLQtIXNFEd78MEx14B8vLZ9y+fPUHH958e3//p+MGD4/s/WkbOqh0cB8VVL7797M9HH6M/nnzz

4uEX5XhZxP/6wye//Px5ORDKZ2He8y8f//b08fOvPv39u4cl8C2Bx0X4iEZEohvkCO3zCAwzXnE1

J2PxaitGIabFFVtxIHGMtZQS/n0VOugbc8zS6Dh6dInrwdsC2kcZ8OrsrqPwMBQzRUskXwsjB7jL

OetyUeqFa1pWwc2jWRyUCxezIm4f48My2T0cO/HtzxLom1laOob3QuKoucdwrHBAYqKQfsYPCCmx

7g6ljl93qS+45FOF7lDUxbTUJSM6drJpsWiHRhCXeZnNEG/HN7u3UZezMqu3yaGLhKrArET5EWGO

G6/imcJRGcsRjljR4dexCsuUHM6FX8T1pYJIB4Rx1J8QKcvW3BRgbyHo1zB0rNKw77J55CKFogdl

PK9jzovIbX7QC3GUlGGHNA6L2A/kAaQoRntclcF3uVsh+h7igOOV4b5NiRPu07vBLRo4Ki0SRD+Z

iZJYXiXcyd/hnE0xMa0GmrrTqyMa/13jZhQ6t5Vwfo0bWuXzrx+V6P22tuwt2L3KambnRKNehTvZ

nntcTOjb35238SzeI1AQy1vUu+b8rjl7//nmvKqez78lL7owNGg9i9hB24zd0cqpe0oZG6o5I9el

Gbwl7D2TARD1OnO6JPkpLAnhUlcyCHBwgcBmDRJcfURVOAxxAkN71dNMApmyDiRKuITDoiGX8tZ4

GPyVPWo29SHEdg6J1S6fWHJdk7OzRs7GaBWYA20mqK4ZnFVY/VLKFGx7HWFVrdSZpVWNaqYpOtJy

k7WLzaEcXJ6bBsTcmzDUIBiFwMstON9r0XDYwYxMtN9tjLKwmCicZ4hkiCckjZG2ezlGVROkLFeW

DNF22GTQB8dTvFaQ1tZs30DaWYJUFNdYIS6L3ptEKcvgRZSA28lyZHGxOFmMjjpeu1lresjHSceb

wjkZLqMEoi71HIlZAG+YfCVs2p9azKbKF9FsZ4a5RVCFVx/W70sGO30gEVJtYxna1DCP0hRgsZZk

9a81wa3nZUBJNzqbFvV1SIZ/TQvwoxtaMp0SXxWDXaBo39nbtJXymSJiGE6O0JjNxD6G8OtUBXsm

VMLrDtMR9A28m9PeNo/c5pwWXfGNmMFZOmZJiNN2q0s0q2QLNw0p18HcFdQD20p1N8a9uimm5M/J

lGIa/89M0fsJvH2oT3QEfHjRKzDSldLxuFAhhy6UhNQfCBgcTO+AbIH3u/AYkgreSptfQQ71r605

y8OUNRwi1T4NkKCwH6lQELIHbclk3ynMquneZVmylJHJqIK6MrFqj8khYSPdA1t6b/dQCKluukna

BgzuZP6592kFjQM95BTrzelk+d5ra+CfnnxsMYNRbh82A03m/1zFfDxY7Kp2vVme7b1FQ/SDxZjV

yKoChBW2gnZa9q+pwitutbZjLVlca2bKQRSXLQZiPhAl8A4J6X+w/1HhM/sFQ2+oI74PvRXBxwvN

DNIGsvqCHTyQbpCWOIbByRJtMmlW1rXp6KS9lm3W5zzp5nJPOFtrdpZ4v6Kz8+HMFefU4nk6O/Ww

42tLW+lqiOzJEgXSNDvImMCUfcnaxQkaB9WOB1+TIND34Aq+R3lAq2laTdPgCj4ywbBkvwx1vPQi

o8BzS8kx9YxSzzCNjNLIKM2MAsNZ+g0mo7SgU+nPJvDZTv94KPtCAhNc+kUla6rO577NvwAAAP//

AwBQSwMEFAAGAAgAAAAhAJxmRkG7AAAAJAEAACoAAABjbGlwYm9hcmQvZHJhd2luZ3MvX3JlbHMv

ZHJhd2luZzEueG1sLnJlbHOEj80KwjAQhO+C7xD2btJ6EJEmvYjQq9QHCMk2LTY/JFHs2xvoRUHw

sjCz7DezTfuyM3liTJN3HGpaAUGnvJ6c4XDrL7sjkJSl03L2DjksmKAV201zxVnmcpTGKSRSKC5x

GHMOJ8aSGtHKRH1AVzaDj1bmIqNhQaq7NMj2VXVg8ZMB4otJOs0hdroG0i+hJP9n+2GYFJ69elh0

+UcEy6UXFqCMBjMHSldnnTUtXYGJhn39Jt4AAAD//wMAUEsBAi0AFAAGAAgAAAAhALvlSJQFAQAA

HgIAABMAAAAAAAAAAAAAAAAAAAAAAFtDb250ZW50X1R5cGVzXS54bWxQSwECLQAUAAYACAAAACEA

rTA/8cEAAAAyAQAACwAAAAAAAAAAAAAAAAA2AQAAX3JlbHMvLnJlbHNQSwECLQAUAAYACAAAACEA

yuDoTOYBAACyBAAAHwAAAAAAAAAAAAAAAAAgAgAAY2xpcGJvYXJkL2RyYXdpbmdzL2RyYXdpbmcx

LnhtbFBLAQItABQABgAIAAAAIQCcTl4h4gYAADocAAAaAAAAAAAAAAAAAAAAAEMEAABjbGlwYm9h

cmQvdGhlbWUvdGhlbWUxLnhtbFBLAQItABQABgAIAAAAIQCcZkZBuwAAACQBAAAqAAAAAAAAAAAA

AAAAAF0LAABjbGlwYm9hcmQvZHJhd2luZ3MvX3JlbHMvZHJhd2luZzEueG1sLnJlbHNQSwUGAAAA

AAUABQBnAQAAYAwAAAAA

" type="#_x0000_t32" o:spid="_x0000_s1026"><v:stroke endarrow="open" startarrow="open"></v:stroke></v:shape><o:p></o:p>​
[/TD]
[TD="width: 144, bgcolor: transparent"][/TD]
[TD="width: 146, bgcolor: transparent"][/TD]
[TD="width: 83, bgcolor: transparent"][/TD]
[TD="width: 101, bgcolor: transparent, colspan: 3"]
<o:p></o:p>​
[/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 126, bgcolor: transparent"]
ملاحظات<o:p></o:p>​
[/TD]
[TD="width: 114, bgcolor: transparent, colspan: 2"]
التوقيع<o:p></o:p>​
[/TD]
[TD="width: 72, bgcolor: transparent"]
وقت الخروج<o:p></o:p>​
[/TD]
[TD="width: 126, bgcolor: transparent"]
التوقيع<o:p></o:p>​
[/TD]
[TD="width: 144, bgcolor: transparent"]
وقت الدخول<o:p></o:p>​
[/TD]
[TD="width: 146, bgcolor: transparent"]
الدائرة<o:p></o:p>​
[/TD]
[TD="width: 134, bgcolor: transparent, colspan: 2"]
رقم التوظيف<o:p></o:p>​
[/TD]
[TD="width: 50, bgcolor: transparent, colspan: 2"]
الاســــــم<o:p></o:p>​
[/TD]
[TD="width: 139, bgcolor: transparent"]
الرقم<o:p></o:p>​
[/TD]
[/TR]
[TR]
[TD="width: 126, bgcolor: transparent"]
REMARKS<o:p></o:p>​
[/TD]
[TD="width: 114, bgcolor: transparent, colspan: 2"]
SIGNATURE<o:p></o:p>​
[/TD]
[TD="width: 72, bgcolor: transparent"]
TIME OUT<o:p></o:p>​
[/TD]
[TD="width: 126, bgcolor: transparent"]
SIGNATURE<o:p></o:p>​
[/TD]
[TD="width: 144, bgcolor: transparent"]
TIME IN<o:p></o:p>​
[/TD]
[TD="width: 146, bgcolor: transparent"]
DIRECTORATE<o:p></o:p>​
[/TD]
[TD="width: 134, bgcolor: transparent, colspan: 2"]
EMP. NO.<o:p></o:p>​
[/TD]
[TD="width: 50, bgcolor: transparent, colspan: 2"]
NAME<o:p></o:p>​
[/TD]
[TD="width: 139, bgcolor: transparent"]
SR. NO.<o:p></o:p>​
[/TD]
[/TR]
[TR]
[TD="width: 126, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 114, bgcolor: transparent, colspan: 2"]
<o:p></o:p>​
[/TD]
[TD="width: 72, bgcolor: transparent"]
15:00<o:p></o:p>​
[/TD]
[TD="width: 126, bgcolor: transparent"]<o:p></o:p>
[/TD]
[TD="width: 144, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 146, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 134, bgcolor: transparent, colspan: 2"]
<o:p></o:p>​
[/TD]
[TD="width: 50, bgcolor: transparent, colspan: 2"]<o:p></o:p>
[/TD]
[TD="width: 139, bgcolor: transparent"]
1<o:p></o:p>​
[/TD]
[/TR]
[TR]
[TD="width: 126, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 114, bgcolor: transparent, colspan: 2"]
<o:p></o:p>​
[/TD]
[TD="width: 72, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 126, bgcolor: transparent"]<o:p></o:p>
[/TD]
[TD="width: 144, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 146, bgcolor: transparent"]
<o:p></o:p>​
[/TD]
[TD="width: 134, bgcolor: transparent, colspan: 2"]
<o:p></o:p>​
[/TD]
[TD="width: 50, bgcolor: transparent, colspan: 2"]<o:p></o:p>
[/TD]
[TD="width: 139, bgcolor: transparent"]
2<o:p></o:p>​
[/TD]
[/TR]
[TR]
[TD="width: 126, bgcolor: transparent"][/TD]
[TD="width: 43, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 72, bgcolor: transparent"][/TD]
[TD="width: 126, bgcolor: transparent"][/TD]
[TD="width: 144, bgcolor: transparent"][/TD]
[TD="width: 146, bgcolor: transparent"][/TD]
[TD="width: 83, bgcolor: transparent"][/TD]
[TD="width: 51, bgcolor: transparent"][/TD]
[TD="width: 26, bgcolor: transparent"][/TD]
[TD="width: 26, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[/TR]
</TBODY>[/TABLE]
<o:p></o:p>
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Sort by date Sort by votes
if a cell shows FRIDAY, I need 12:00 in another cell
if it is SATURDAY, I need 15:00 in another cell
if it is SUNDAY, MONDAY, TUESDAY, WEDNESDAY
Click to expand...
where you need 12:00 or 15:00 ?
or.. what is your expectation if it is Sunday, Monday, Tuesday and Wednesday ?


Regards,
DILIPandey
 
Upvote 0
DILIPandey said:
where you need 12:00 or 15:00 ?
or.. what is your expectation if it is Sunday, Monday, Tuesday and Wednesday ?


Regards,
DILIPandey
Click to expand...

This is for preparing a time sheet. Suppose the date in the topmost cell is 01 April 2016 Friday, i would like to get 12:00 in the TIME OUT cell. Like this 15:00 for Saturday and 19:00 for other days.
[TABLE="width: 1029"]
<tbody>[TR]
[TD="colspan: 13"][/TD]
[/TR]
[TR]
[TD="colspan: 2"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]DATE
[/TD]
[TD="colspan: 4"]Friday, April 01, 2016
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"][/TD]
[TD]
[/TD]
[TD="colspan: 3"][/TD]
[/TR]
[TR]
[TD]ملاحظات
[/TD]
[TD="colspan: 2"]التوقيع
[/TD]
[TD]وقت الخروج
[/TD]
[TD]التوقيع
[/TD]
[TD]وقت الدخول
[/TD]
[TD]الدائرة
[/TD]
[TD]رقم التوظيف
[/TD]
[TD="colspan: 2"]الاســــــم
[/TD]
[TD="colspan: 3"]الرقم
[/TD]
[/TR]
[TR]
[TD]REMARKS
[/TD]
[TD="colspan: 2"]SIGNATURE
[/TD]
[TD]TIME OUT
[/TD]
[TD]SIGNATURE
[/TD]
[TD]TIME IN
[/TD]
[TD]DIRECTORATE
[/TD]
[TD]EMP. NO.
[/TD]
[TD="colspan: 2"]NAME
[/TD]
[TD="colspan: 3"]SR. NO.
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD="colspan: 2"]
[/TD]
[TD]12:00
[/TD]
[TD]
[/TD]
[TD]7:00
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD="colspan: 2"]
[/TD]
[TD="colspan: 3"]1
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD="colspan: 2"]
[/TD]
[TD="colspan: 3"]2
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD="colspan: 2"]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD="colspan: 2"]
[/TD]
[TD="colspan: 3"]3
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Okay.. assuming topmost cell is a1, use below formula to get desired output:-

=IF(TEXT(A1,"DDD")="Fri",TIME(12,0,0),IF(TEXT(A1,"DDD")="Sat",TIME(15,0,0),TIME(19,0,0)))

Format the cell containing formula as time with format 13:00


Regards,
DILIPandey
 
Upvote 0
DILIPandey said:
Okay.. assuming topmost cell is a1, use below formula to get desired output:-

=IF(TEXT(A1,"DDD")="Fri",TIME(12,0,0),IF(TEXT(A1,"DDD")="Sat",TIME(15,0,0),TIME(19,0,0)))

Format the cell containing formula as time with format 13:00


Regards,
DILIPandey
Click to expand...
THANK YOU VERY MUCH DILIPandey, it works. thank you, thank you
 
Upvote 0
You must log in or register to reply here.

Similar threads

Leicester City Fox
  • Question Question
Need Formula that only show that only the latest positive results and if negative shows zero in latest wk
Replies
5
Views
426
Leicester City Fox
Leicester City Fox
S
  • Question Question
Finding Intersection? Possibly?
Replies
0
Views
442
ShruggedTundra
S
S
  • Question Question
logical OR 2 columns and conctenate reesult in VBA
Replies
4
Views
540
stravo
S
A
  • Question Question
DAX Max Month Measure
Replies
4
Views
3K
gazpage
G
B
  • Question Question
Can anyone help with a Macro please
Replies
3
Views
359
CROY1985
C

Forum statistics

Threads
1,224,552
Messages
6,179,484
Members
452,917
Latest member
MrsMSalt

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top